MadHatsJess
New Member
- Joined
- Jul 12, 2017
- Messages
- 27
Hi
I have a central spreadsheet that will be fed by around 20 identical reports (apart from the data).
I am using the simple formula below to pull it together (will be refreshed monthly and the file names will be the same)
='C:\File path\[Report 1.xlsx] Main Report Report '!$C$9
='C:\File path\[Report 2.xlsx] Main Report Report '!$C$9
Is there away to reference the bold part of the formula to a cell in excel with the file name?
This would save me about 10 hours :D
Thanks in advance
Jess
I have a central spreadsheet that will be fed by around 20 identical reports (apart from the data).
I am using the simple formula below to pull it together (will be refreshed monthly and the file names will be the same)
='C:\File path\[Report 1.xlsx] Main Report Report '!$C$9
='C:\File path\[Report 2.xlsx] Main Report Report '!$C$9
Is there away to reference the bold part of the formula to a cell in excel with the file name?
This would save me about 10 hours :D
Thanks in advance
Jess