Automate data gathering from separate worksheets

  • Thread starter Thread starter etpierce
  • Start date Start date
E

etpierce

I want to automate formulas on a dashboard worksheet. When I ente
'Fred' in cell A1 of the dashboard, I want all formulas in tha
dashboard worksheet to pull data from the 'Fred' worksheet located i
the same workbook.

For example, I have a workbook with worksheets named 'Dashboard'
'Fred' and 'Bob'. When I enter 'Fred' in cell A1 of my dashboar
worksheet, I want all formulas on the dashboard to reference data i
the Fred worksheet as in "=Fred!C47" or "=SUM(Fred!X58:X62)". If
enter 'Bob' in cell A1 of the dashboard, the forumlas would referenc
new values in the Bob worksheet as in "=Bob!C47" o
"=SUM(Bob!X58:X62)".

Any suggestions are appreciated. :confused
 
You can use INDIRECT...

=INDIRECT("'"&A1&"'!C47")

and

=SUM(INDIRECT("'"&A1&"'!X58:X62"))

Hope this helps!
 
Back
Top