Phillip Rogers
New Member
- Joined
- Jan 19, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
I have a dashboard that pulls data from another spreadsheet. Each months it is named "Maltb Dashboard "month and year".
On the dashboard I want to reference source files that that have not been created yet but, I do know the names.
Example
=IFERROR('C:\Users\Phill\one\PR FILES\Store Dashboard Info\[Maltb Dashboard January 2021.xlsm]Dashboard'!$U$52,0)
I was hoping to copy the formula across for the 50 rows in the column
Use find / replace to change the file names on all the cells in that month row
My issue is that when I rename the cells with future file names, excel opens an "update values box"(obvs don't have that file yet). I can hit ESC but it only changes that one cell even though I have highlighted the whole column using FIND / REPLACE
On the dashboard I want to reference source files that that have not been created yet but, I do know the names.
Example
=IFERROR('C:\Users\Phill\one\PR FILES\Store Dashboard Info\[Maltb Dashboard January 2021.xlsm]Dashboard'!$U$52,0)
I was hoping to copy the formula across for the 50 rows in the column
Use find / replace to change the file names on all the cells in that month row
My issue is that when I rename the cells with future file names, excel opens an "update values box"(obvs don't have that file yet). I can hit ESC but it only changes that one cell even though I have highlighted the whole column using FIND / REPLACE