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

JLeibovitz

New Member
Joined
Apr 10, 2013
Messages
6
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!
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Akashwani

Well-known Member
Joined
Mar 14, 2009
Messages
2,911
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
ABCDEF
1Data1Data2Data3Data4Data5
2RedBillCat1Bus
3BlueBenDog2Bike
4PinkBobRat3Van
5GreenBudCow4Car
6
Sheet22


Example results....

Excel Workbook
ABCDEF
2Drop DownResult1Result2Result3Result4
3Data1RedBluePinkGreen
4
5Data3CatDogRatCow
6
Sheet21


The formulas above need to be copied across.

I hope this helps.

Ak
 

Akashwani

Well-known Member
Joined
Mar 14, 2009
Messages
2,911
Hi Jessica.

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

Ak
 

Watch MrExcel Video

Forum statistics

Threads
1,123,088
Messages
5,599,664
Members
414,325
Latest member
kfg1287

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top