Hi - I am trying to consolidate different a specific sheets from different workbooks into 1 workbook maintaining the pivot format and formulas
Here's what I am trying to do:
1. Copy or move the data from sheet 1 with specific names to a single workbook
2. Data is in Pivot form/Data only
2. Sheet name should be in order based on the lists
3. Error in opening the file should be resolved as well
Here's what I am trying to do:
1. Copy or move the data from sheet 1 with specific names to a single workbook
2. Data is in Pivot form/Data only
2. Sheet name should be in order based on the lists
3. Error in opening the file should be resolved as well
Last edited by a moderator: