michelleb376
New Member
- Joined
- Mar 4, 2011
- Messages
- 1
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?