merge workbooks

  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. R

    Combine Workbooks

    Hello Everyone, i am working on a project and bit new on macro area need to do some amendment in workbook saved in folder. please find below I have an excel where i have button. now in A1 there is path of folder and in B1 i have file name Test1.xlsx and in B2 Test2.xlsx (only one sheet...
  3. J

    Merging single worksheet from different workbooks using VBA

    Hi, I am trying to merge a single worksheet from 11 workbooks in a single location into a master workbook. I have used the VBA below but I don't want there to be any spaces between the merges and there is on this script Sub simpleXlsMerger() Dim bookList As Workbook Dim mergeObj As Object...
  4. K

    VBA to Merge Sheet1 of Multiple Workbooks in Same Folder

    I see a variety of code for what I am looking to do. Ron de bruin's code is almost exactly what I need, but need help with part of it as the row range must be dynamic. I have 20+ workbooks with different names in one folder. I need to stack the data from each workbook into one worksheet in a...
  5. L

    trouble with VBA code to merge workbooks

    I'm using Ron de Bruin's code for merging workbooks and have modified a couple things. For one, I changed the code so that rather than open a new blank worksheet, I want to use the already open excel file in which I have some custom headings, not the headings from the worksheets I'm merging...
  6. D

    Merging Multiple Workbooks into Master Wbook

    Hi Excel Experts, I found this awesome vba code to allow me copy every wsheet from multiple workbooks into one Master Wbook, then move the file to folder named "Done" in the same Master Wbook path. However, when it finds that the file it moves already exist in folder "Done", the macro will stop...
  7. J

    VBA Consolidation of multiple workbooks

    Hi. I am pretty clued up using excel, but my VBA knowledge is very limited, so I was hoping that someone may be able to offer some assistance. I have created a resourcing master file and I have also created a resource submission form, which is basically another excel spreadsheet, which will be...
  8. D

    Merging Workbooks into Master & move the subworkbooks into other folder

    Hi Excel Experts, Am trying to code down macros that can do the following:- 1. Copy sheet from multi workbooks (in same folder) into 1 main (Compiler) excel workbook (separated by tabs) 2. Each time after the sheet is copied into Compiler workbook, the source file should be moved to another...
  9. D

    Creating a Macro to compile from different Workbooks

    I work with some software that generates various reports as excel docs. The naming convention is always the same for these documents. There are a total of 4 documents I draw from to make a final report. Most of the numbers on this final report are simple cut and paste from one workbook into...
  10. A

    Combine only first sheets of multiple workbooks to one workbook

    Hello, I learned a lot from this forum, it helped me almost every time I needed something. But now I came to a wall, which I can't crush. I found a lot of threads to this problem, but didn't get the result I wanted. I have a workbook for each month, every workbook contains data of errors from...
  11. U

    Combine Data From Multiple (42) Workbooks / Files with Multiple Worksheets /Tabs Excel 2010

    Hi, I have 42 excel files with 2 tabs of multiple columns each. All layouts and column titles are the same. Every workbook was sent to me "shared", which has created several limitations. I can unshare a file when it is opened and get back full capabilities, but I don't know how to do this...
  12. P

    Merging Excel Workbooks

    Hi, all! I was wondering if Excel has a merge function - similar to Word's merge function. Here is the scenario: A coworker and I have been working on 2 different copies of the same workbook. We updated it with reference numbers and lines with arrows. Now, we need to combine our work into...
  13. B

    'Merging' 10 Workbooks - HELP

    I have 10 Excel Shared Workbooks, all in the same format, but with different result information. Each workbook has 16K rows of information, the basic information is the same. For reporting purposes I thought I could just 'merge' the workbooks into a master report so that I could monitor the...
  14. A

    Merge data from workbooks

    I need help merging some data. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> I have 12 workbooks in a folder for each month of the year. Each workbook has a worksheet name “Hypo”. I need data from L3 to L32 on the “Hypo” sheet. Any help would be...
  15. G

    Compare two workbooks and find differences

    We have a need to compare two workbooks, which have identical structures, to determine which names have been added and which have been removed. Each workbook has multiple sheets which would need to be compared. Any suggestions would be greatly appreciated!
  16. S

    Merge worksheet contents with different headers - help please

    I am amazed at the things that I have seen on this forum - what you can do with excel is incredible.:) I have many worksheets (40-50) from different sources with some or all of the information I need (language problem-community development work). The worksheets provided to me do not have all...
  17. D

    Need Help Combining Workbooks!!

    I have a data source the only allows me to download 500 listings at one time. I have created a marco to get all of the data but them am left with about 80 workbooks of info that i need to be in one sheet. Thanks for any help on this one!
  18. J

    Mater file (locked) with subfiles

    Hi all, I'm pretty sure this isn't the most difficult task, but I can't quite figure it out. I need 5 or 6 single sheet workbooks all with the same 20 columns, but each with different sections of data below and of varying lengths (some to be chosen from spedific drop down lists) , all...
  19. M

    Trouble Merging seperate Workbooks

    Hello – I’m new here and would consider myself an intermediate-level (barely) Excel user. Currently using Excel 2007 on Windows XP Pro. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> Having trouble merging data from one workbook with three separate...

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