+ Reply to Thread
Results 1 to 5 of 5

Merge multiple excels with multiple sheets in a master excel with multiple sheets

  1. 02-15-2012, 08:06 AM #1
    marchi
    marchi is offline
    Registered User
    Join Date
    02-15-2012
    Location
    bucuresti
    MS-Off Ver
    Excel 2007
    Posts
    2

    Question Merge multiple excels with multiple sheets in a master excel with multiple sheets

    Hello!

    I've looked for several days and I didn't find an answer, so I need your help. I have 5 workbooks and each workbook has 10 sheet , I whant to collect all the information in a workbook named Master ( e.g. Workbook1 sheet A, Workbook 2 sheet A, Workbook 3 sheet A, Workbook 4 sheet A, Workbook 5 sheet A in a workbook master sheet A; Workbook1 sheet b, Workbook 2 sheet b, Workbook 3 sheet b, Workbook 4 sheet b, Workbook 5 sheet b in a workbook master sheet b from etc. b. I need to copy the data but not the head of the table. Data will be added each day.

    Is there any possibility of a macro to do this?

    I hope i has clear...If not please tell me...I don't write in English very well.

    Thank you in advance!
    Reply With QuoteRegister To Reply
  2. 02-15-2012, 08:54 AM #2
    Kelshaer
    Kelshaer is offline
    Valued Forum Contributor
    Join Date
    08-29-2011
    Location
    Mississauga, CANADA
    MS-Off Ver
    Excel 2010
    Posts
    503

    Re: Merge multiple excels with multiple sheets in a master excel with multiple sheets

    yes
    What if the master workbook already has values in lets say SheetA. Do you want to delete thais data before importing or appending it?
    Regards,
    Khaled Elshaer
    www.BIMcentre.com

    Remember To Do the Following....
    1. Thank those who have helped you by clicking the Star below their post.
    2. Mark your post SOLVED if it has been answered satisfactorily:
    • Select Thread Tools (on top of your 1st post)
    • Select Mark this thread as Solved
    Reply With QuoteRegister To Reply
  3. 02-15-2012, 09:07 AM #3
    marchi
    marchi is offline
    Registered User
    Join Date
    02-15-2012
    Location
    bucuresti
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Merge multiple excels with multiple sheets in a master excel with multiple sheets

    Appending data.
    Reply With QuoteRegister To Reply
  4. 02-15-2012, 10:15 AM #4
    Kelshaer
    Kelshaer is offline
    Valued Forum Contributor
    Join Date
    08-29-2011
    Location
    Mississauga, CANADA
    MS-Off Ver
    Excel 2010
    Posts
    503

    Re: Merge multiple excels with multiple sheets in a master excel with multiple sheets

    Here you Go:
    This one will delete the old data every time you run the macro
    I added some hints so you can know how it works
    Please Login or Register  to view this content.
    Last edited by Kelshaer; 02-15-2012 at 10:37 AM.
    Reply With QuoteRegister To Reply
  5. 02-15-2012, 10:37 AM #5
    Kelshaer
    Kelshaer is offline
    Valued Forum Contributor
    Join Date
    08-29-2011
    Location
    Mississauga, CANADA
    MS-Off Ver
    Excel 2010
    Posts
    503

    Re: Merge multiple excels with multiple sheets in a master excel with multiple sheets

    This one will append the new data to the existing

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1