merge workbooks

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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!
  14. 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...
  15. 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!
  16. 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...
  17. 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...

Some videos you may like

This Week's Hot Topics