Transpose Named Range (List) into Row based on a Cell Value

[JLeibovitz]

I've searched high and low and can't seem to find anything that works and I'm hoping that one of you will take pity on me and help me out.

What I'm trying to do:

1. User selects a value from a drop-down list
2. This value determines references which named list of headers on another page should be used
3. All items in this list should then be transposed into the appropriate row, back on the sheet where the user made the drop-down menu selection.

Is this possible?
I'd prefer to do this without VBA if at all possible (I'm not a particularly good coder), but can give it a shot if it's the only way around the issue.

Thanks in advance!

 

[Akashwani]

Hi and welcome to MrExcel.

Can you provide some sample data of your data on the 2nd sheet and the expected results on the 1st sheet?

Something like this....

Sample Data....

Excel Workbook
	A	B	C	D	E	F
1	Data1	Data2	Data3	Data4	Data5
2	Red	Bill	Cat	1	Bus
3	Blue	Ben	Dog	2	Bike
4	Pink	Bob	Rat	3	Van
5	Green	Bud	Cow	4	Car
6
Sheet22

Example results....

Excel Workbook
	A	B	C	D	E	F
2	Drop Down	Result1	Result2	Result3	Result4
3	Data1	Red	Blue	Pink	Green
4
5	Data3	Cat	Dog	Rat	Cow
6
Sheet21

The formulas above need to be copied across.

I hope this helps.

Ak

 

[JLeibovitz]

Hi and welcome to MrExcel....

Hi Ak, and thank you for the warm welcome!

Your solution worked like a charm.

Best,
Jessica

 

[Akashwani]

Hi Jessica.

I'm pleased it worked for you and thanks for the feedback.
You now know where to come for all your Excel headaches!!

Ak