collate workbooks

  1. D

    Collate multiple Excel files into one worksheet

    I have multiple files that are the exact same data format, all the same columns but different data, and I want to be able to select all of these files and get them to all compile into one file in one worksheet. As they all have the same headings they would just need to be copied one below the...
  2. A

    Combining cells from multiple worksheets into rows on single worksheet

    Hi, I am hoping someone is able to help me. I have a workbook with about 300 tabs. All exactly the same format. I am trying to write a macro that copies all of the data from several cells in each workbook into a single workbook. Let me give more an example. A1 - First Name B1 - Last Name C1 -...
  3. A

    Collating data into single worksheet

    I have two workbooks with 3 tabs each. I want to collate data from above 2 workbooks into a single worksheet.The macro should copy header from only one sheet and rest worksheet data below it. The data count in each tab is not fixed whenever I am going to run the macro. Any help on how I can...
  4. E

    Collate all spreadsheets .xls* in the current folder depending on a specific cell value.

    Hi guys! I have a challenge for you. I am having a problem with multiple reports no uniformity of columns so I thought of these but I don't know how to do it. This is the scenario. 1. There are x numbers of spreadsheets and worksheets within with different column names in it. 2. I thought of...

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
Back
Top