VBA Code to move sheets from different workbooks to a masterfile

Mel0620

New Member
Joined
Jun 24, 2021
Messages
4
Office Version
  1. 365
Platform
  1. Windows
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
 
Last edited by a moderator:

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Mel0620

New Member
Joined
Jun 24, 2021
Messages
4
Office Version
  1. 365
Platform
  1. Windows
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. Open the workbook from specific folder based from the lists
2. Copy the data in specific sheet
2. Paste the data to another workbook
3. Rename the tab

Here's what I am trying to do:
1. Open the workbook from specific folder based from the lists
2. Copy the data in specific sheet based on the lists
2. Paste the data to another workbook
3. Rename the tab same from the original workbook
4. Open again next workbook based from the lists
5. Copy the data in specific sheet based on the lists
6. Rename the tab same from the original workbook
7. Repeat until the lasts lists
8. Save the workbook as binary
 

Forum statistics

Threads
1,141,315
Messages
5,705,699
Members
421,406
Latest member
kluna90

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top