I have a report spreadsheet that I use monthly. It uses data from multiple workbooks that are linked to it. To update the report every month, I copy the tab from the last month and update the links. I use the Find & Replace method to update the values (ex. Find "Jul" and replace with "Aug").
The main problem I have is when I do this, the windows explorer box pops up asking me which file to use for each link I have. There are ~100 cells that use linked data so I end up having to choose the current month data file for every linked cell. I can't seem to get around this. Any thoughts?
Much thanks in advance!
Bookmarks