Linking data from monthly reports

[michelleb376]

There are two reports one that we regenerate (copy and clear out old data) for new monthly data, and another that is created by another user on a shared drive. We would like to have the data automatically pulled from the other users document but the name changes with each month to reflect the current month. Is there a way for excel to recognize or mass change the different linked cells to reflect the new workbook name or do I have to go into each cell and update the name of the workbook we are pulling from?

 

[jberwald]

If the cell locations for the data you require stays the same each month, a Find and Replace can do a mass change in the formulas to change the workbook name.