Results 1 to 3 of 3

Combine 2 workbooks together with multiple worksheets

Threaded View

  1. #1
    Registered User
    Join Date
    06-19-2008
    Posts
    5

    Combine 2 workbooks together with multiple worksheets

    Hi all,

    I have been searching for ever now and can't seem to find what I am looking for...(maybe I am wording it wrong)

    What I have to do is take Workbook 1 and copy all the data and paste it under all the data in Workbook 2... and do this for about 200 worksheets per workbook, all of them with the same titles.

    So for example....

    Take all of the rows with data in them starting with row 4, from Workbook 1, Worksheet 1 and paste them under all the rows with data in Workbook 2, Worksheet 1.

    Then.... go to Worksheet 2, then Worksheet 3 and so on...

    I program in Java, and know a little about VBA, but not nearly enough to get this hammered out... Any help would be greatly appreciated.

    Thanks
    Last edited by VBA Noob; 09-11-2008 at 03:05 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Append multiple workbooks with multiple worksheets
    By samirz10 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-10-2008, 02:28 PM
  2. Automatically format multiple worksheets
    By Kez in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-29-2008, 08:25 AM
  3. Multiple charts over multiple sets of data over multiple worksheets.
    By matrocka in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-12-2007, 10:01 AM
  4. Run Macro on Multiple Workbooks (.csv) Files at Once
    By davehunter in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-26-2007, 10:52 AM
  5. Printing different worksheets from multiple workbooks
    By andycreighton in forum Excel General
    Replies: 8
    Last Post: 01-11-2007, 08:27 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1