Natemoney2
New Member
- Joined
- Sep 26, 2008
- Messages
- 32
I have multiple Workbooks.
!24 Facilities that each have their own P&L pulled in the same format for each so my source Account names are consistent throughout each workbook.
I have created a summary report that pulls data from the P&L.
If I copy that worksheet to another Facility Workbook it automatically links back to the Source workbook even though the worksheet reference name is the same in ALL Workbooks.
I can do a Find Replace each time I make a copy but there must be an easier way to do this.
Open to suggestions.
!24 Facilities that each have their own P&L pulled in the same format for each so my source Account names are consistent throughout each workbook.
I have created a summary report that pulls data from the P&L.
If I copy that worksheet to another Facility Workbook it automatically links back to the Source workbook even though the worksheet reference name is the same in ALL Workbooks.
I can do a Find Replace each time I make a copy but there must be an easier way to do this.
Open to suggestions.
