Thread: [Solved] pull data using drop down menu
View Single Post
 
Old 03-20-2016, 06:59 AM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
I am not sure what you mean.

You write: How do I create the drop down menu to pull from sheets?

In your original message you wrote:
main sheet has the drop down menu, when I select sheet 2 from drop down menu, I would like it to pull all pricing listed in a column on sheet 2 to the main sheet

and that is what my formulas in main do based on the sheet name chosen in the drop down in C2. You didn't mention that it isn't every row you want to pull over.

Maybe it would be an idea to attach a file showing the structure and expected results.
Reply With Quote