merging files

  1. D

    Merging spreadsheets using a macro

    I have 3 excel sheets, listed below, I need to merge them into a new spreadsheet 'Master_Signups & Testing'. The 3 different spreadsheets below contain the same columns but the information in the rows are different and new rows are always being added. Is there a way to add a macro to...
  2. T

    Merging multiple excel files into one.

    Hi, I have about 70 excel file that share the same column headers and would like to know if there's an easy/fast way of adding them automatically into 1 single master file? Thank you.
  3. A

    Need help: Combining two excels with same first name string into one excel with two worksheet

    Hello Everyone, I have multiple excel files in a folder with names "A 08-24-16 File1", "A 08-24-16 File2", "B 08-24-16 File1", "B 08-24-16 File2", etc.. I need help with VBA/Macro to combine two excels with same first name (in this case all A together, then all B together) with the output name...
  4. M

    Workbook Split and Re-Unification

    So I need a bit of help with an existing macro. I need to split a workbook's multiple worksheets into multiple files (not based on worksheet name). The project: It deals with very sensitive HR/performance data, and I need to send 1000s of employees' data to their individual managers (about 100...
  5. W

    Merging different versions

    I have a requirement to prompt a user to select 2 files from a defined default LAN directory. File1 is a excel 2010 .xlsx file File2 is a .csv file File1 contains multiple tabs named Tab1, Tab2, Tab3 ... Tab(N). File2 contains some header infomation followed by multiple rows of data and some...
  6. P

    Combining spreadsheets.

    Hi all, As always there are several solution to a problem so I am interested to see what others would do in the following situation: Let's assume I have five spreadsheets with the same layout; the contents refers to different countries and I would like to add them all together in a new...
  7. B

    copy multiple excel files in a workbook as sheets

    Hi, I need to copy individual excel files and create a single workbook with each file as a worksheet tab. the original files have only one worksheet each. Is there any way to automate this process, since I need to do this on a weekly basis with around 20 files? If this has already been...

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