Hi
I have 6 department workbooks and 1 summary workbook. The summary workbook is set up to consolidate the 6 department workbooks. My problem is that every month when the 6 workbooks get updated, I have to go the summary sheet and delete the previous information and select Data/Consolidation and click ok to retrieve the updated information. I do not want to create links to the 6 worksheets.
Is there a way around this?
Any help will be greatly appreciated.
I have 6 department workbooks and 1 summary workbook. The summary workbook is set up to consolidate the 6 department workbooks. My problem is that every month when the 6 workbooks get updated, I have to go the summary sheet and delete the previous information and select Data/Consolidation and click ok to retrieve the updated information. I do not want to create links to the 6 worksheets.
Is there a way around this?
Any help will be greatly appreciated.