merge multiple workbooks

  1. V

    Merge Workbook in VBA

    I am attempting to merge multiple files from a folder into one workbook. So far I have been able to merge the data, but when I attempt to add the file name in last column of the the results I am getting an error message. I am really new to VBA and any help is greatly appreciated. The error...
  2. J

    Need a Excel macro to consolidate data from a specific tab from many excel files

    Hi Guys, I have never posted before but I am hoping that someone will know how to knock this out. My admin is going crazy opening all these files and then cutting and pasting little snippets into one merged file! I have to believe a macro type VBA program can help here. We need a...
  3. L

    Summarizing several workbooks

    I have worked in excel for a number of years but have always done things the hard/long way I guess you could say. Looking for a little help with a fairly large task to save a bit of time and sanity. I have 4 years of data that I need to total and summarize. Within those 4 years I have 25...
  4. O

    Merge Multiple Excel Workbooks with Macro

    Hi all, I am stuck and would really appreciate your help in this regard, and I thank you in advance!: I need to write an app in excel that will merge multiple excel workbooks into one workbook (this could possibly be a macro / or vba UserForm containing the process that reads the workbooks...
  5. T

    Excel 2003 - Trying to merge multiple caseworker notes, saved in different directories into a master

    I have a number of staff recording there case notes on individual workbooks in their named folder. Labels along the top = Client ID (number) Date (date) Action (Text) Staff (Text) Basically they complete this everytime they work with a client to keep notes. I want to be able to merge each...
  6. K

    Merging Excel Files = Formatted Word or PDF Report

    I'm trying to merge two Excel files and output a single, nicely formatted pdf or Word report that combines the two Excel spreadsheets. Could you please tell me if that is possible and if so, how? I'm looking to take the results of an online form (40% of the final report information), that...
  7. J

    Challenge two worksheets query and merge !!

    Dear Excel Gurus I have tried looking up answers and never realized how difficult it would be to bring data from two worksheets into one- seemed simple when I took on the task. So here goes.....I am working with two worksheets that are different sizes (meaning unknow number of entries as it...
  8. I

    Merge Excel columns from different worksheets to new sheet

    Using Excel 2003, I have a workbook with 7 worksheets each containing 160 rows plus a header, each worksheet has a key field (employee number) and several unique columns. Looking for an easy to understand solution to merge the columns from all the worksheets into a new sheet - once data is...
  9. D

    Merge data from multiple files based on a "true" value

    Hi, I am new at this and I am trying to figure out how to merge data from many excel 2007 workbooks (Win 7), in one folder, into one worksheet. Each workbook has 3 worksheets, all worksheets are protected by password (all have same password) all I need is the data from the first worksheet. The...

Some videos you may like

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