I have a few sheets in excel, I have a drop down menu that has each of the sheets names in the drop down.



call it sheet2sheet 3 sheet 4 plus I have the first sheet "main sheet"

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

Take a look here

Attached Files

pull_data.xlsx (11.2 KB, 11 views)

Yes! that is the idea of what I need. How do I create the drop down menu to pull from sheets? also my sheet is a lot more complex. is the formula the same? can you show me where I would enter then cell numbers.

I have two columns that need to pull over but not every row. there is about 40 rows that need to pull over

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.

Sorry for the confusion, I was thinking I could get enough info to be able to expand, but realize now it is more complex then I thought. haha

I have attached a sample, The first page is "main sheet" this is the one I will be using to enter data into.

On the "main Sheet" I would like a drop down menu in projects(top of the page) that has all sheets at the bottom "project1" "Project 2" "project3" and so on.

The highlighted parts in yellow is what I would like to pull in from each sheet.

So instead of hitting tab on bottom of sheet to get project, I would just select "main sheet" click drop down menu select "project 2" and all info in yellow from "project 2" would load to "main sheet" then I would be able to enter data that I need and save under new name.

The is is just one section, I would have all most 40 rows of info to cross over, and there is blank spaces between rows.

Hope this better explains, thanks for helping!!!

Attached Files

example project.xlsx (36.1 KB, 9 views)

Is it like this?

Attached Files

pull_data_2.xlsx (11.2 KB, 14 views)

works like what you have done, I have attached my example on last one not sure if your able to use that. are you able to share the steps I need to do

Sorry, I happened to attach the wrong file.

The formula =INDIRECT("'"&$C$2&"'!RC",0) takes the value from the same cell (as where the formula resides) from the sheet specified in Main sheet!C2. The formula assumes that all sheets have the same structure.

Attached Files

example project_2.xlsx (36.5 KB, 10 views)

It would be nice to have just a short response from you.