consolidate files

  1. U

    VBA: Consolidate Data Sheets Except for One

    Hello Gurus, I'm currently working on a project and using below VBA codes. Sub Consolidate Application.ScreenUpdating = False Dim LastRow As Long, ws As Worksheet, desWS As Worksheet LastRow = Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row If Not...
  2. 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...
    • unknownymous
    • Thread
    • combine data consolidate files excel 2016 vba macro merge workbooks microsoft 2016
    • Replies: 4
    • Forum: Excel Questions
  3. 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...
    • pbennall
    • Thread
    • consolidate files excel 2010 power query timestamp vba
    • Replies: 1
    • Forum: Excel Questions
  4. 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...
  5. 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...
    • angelicah
    • Thread
    • consolidate consolidate files consolidate workbooks consolidating data consolidating worksheets
    • Replies: 0
    • Forum: Excel Questions
  6. 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...
  7. 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

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