Hi guys,
Can you please help me out with this one.
I need a master sheet that will populate the data in the sheet based on other sheets in the workbook. These sheets will have the person's name as a name, and on the master sheet you will see the drop down box with their names.
As you select a name from the drop down, I want the tables below to autopopulate.
Can you help me with this please!
I thank you all in advance for your help
Last edited by TalResha; 01-06-2011 at 09:55 AM.
If I read your question correctly, you want a formula in all the cells on your Master sheet that will cause the sheet to reflect all the values in the sheet named for the person you select in cell F2.
That's possible with the INDIRECT() function, but I see no benefit here. If I click on the sheet tab John I am already looking at this exact report. Reflecting it identically in another sheet seems pointless.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Hi,Originally Posted by JBeaucaire
Thank you for your quick reply. It does seem pointless when you look at it like this, the reason I need the mastersheet to populate based on the drop down is because I am building a dashboard which will have graphs pointing to this mastersheet.
The graphs will need to change based on the Person they select. Thus I need a mastersheet where the name will change, thus populating the values for that person allowing me to see the graph and ratios for that person only.
I hope this makes more sense now.
This formula in F3, then copied to everywhere else you want to work:
=INDIRECT("'" & $F$2 & "'!" & ADDRESS(ROW(),COLUMN()))
Use the trick outlined on this page to hide all the zero values, if you wish:
http://office.microsoft.com/en-us/ex...010070461.aspx
Or just go into Tools > Options > View > [ ] Zero Values and uncheck that for this one sheet.
Last edited by JBeaucaire; 01-06-2011 at 08:32 AM.
Brilliant, it works like a charm and does exactly what I wanted it to do!
Changing topic to solved
Last edited by TalResha; 01-06-2011 at 09:54 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks