Mark McInerney
Active Member
- Joined
- Apr 4, 2012
- Messages
- 283
- Office Version
- 365
- Platform
- Windows
I have 52 spreadsheets - named "SalesWeek1", "SalesWeek2", "SalesWeek3"......"SalesWeek52"
These spreadsheets capture the sales data for my business. The format/structure of each spreadsheet is the same i.e. Cell A1 contains Sunday Sales and does so in each of the spreadsheets.
I want to create a KPI spreadsheet that extracts data from the other sheets. I can enter a formula
='W:\Whitethorn Test\[WorksheetA.xls]SalesWeek1'!$A$1
and this will bring back the data, but it is time consuming. Is there a way for me to select the spreadsheet name from a drop down box and retrieve the data in Cell A1 from the spreadsheet name that I select?
Thanks for any help - much appreciated.
These spreadsheets capture the sales data for my business. The format/structure of each spreadsheet is the same i.e. Cell A1 contains Sunday Sales and does so in each of the spreadsheets.
I want to create a KPI spreadsheet that extracts data from the other sheets. I can enter a formula
='W:\Whitethorn Test\[WorksheetA.xls]SalesWeek1'!$A$1
and this will bring back the data, but it is time consuming. Is there a way for me to select the spreadsheet name from a drop down box and retrieve the data in Cell A1 from the spreadsheet name that I select?
Thanks for any help - much appreciated.
