consolidate files

  1. U

    VBA: Combine data from Multiple Workbooks Into One File and Consolidate into one Tab

    Hello Gurus, Good day! Could you possibly help me tweak below code? I have multiple workbooks and need to combine into one. I have below code that can do it. However, I am getting an error message whenever there is same tab name that exists on different workbook. Note that the tab name most...
  2. P

    Querying a single cell from multiple workbooks

    I have a large number of workbooks all created from the same template file. They are all formatted in an identical manner, and each worksheet has a timestamp in cell A4 that I'm interested in extracting. I'm trying to consolidate the filename and timestamp (cell ref A4) from each worksheet...
  3. A

    Consolidate multiple file in designated folder (Invalid code for long figues)

    I used the following code to consolidate the data in multiple files in a designated folder. The codes work perfect when the source files are excel but there is issue with csv/txt file. When it is csv/txt file, if value of the cell is some figures with many digits, the copied value changes in...
  4. A

    Consolidating 2 Excel Workbooks into one workbook

    I am trying to consolidate 2 Excel workbooks that have multiple tabs. There are 2 people working out of the same workbooks each saved to their own computer but not necessarily working on the same tab. Anyways, once each person has worked their sections then it is time to combine the tabs in...
  5. B

    Consolidate worksheets & copy the name of the tab in a column

    Hello, I am trying to consolidate a spreadsheet with 45 worksheets. I want to copy all the data into one worksheet and call it master. I also need to copy the name of the worksheet next to the data in a separate column. I have three columns: 1) Recipient 2) Email Address 3) Comments the...
  6. T

    Macro

    I get sent 5 seperate excel sheets from different teams on a monthly basis. I then normally copy and past them into one overall monthly sheet. Is there a Macro that can automatically do that, any help appreciated

Watch MrExcel Video

This Week's Hot Topics

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