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!!!
|