Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Feb 2015
    Thanked 0 Times in 0 Posts

    How to use VBA to copy 5 sheets paste to 1 new workbook by appending

    Hi, I am a beginner of VBA. I try to copy 5 sheets paste into 1 workbook named "Import". Each sheet contains about 1000-2000 rows and I want to append 5 sheets in "Import" sheet.
    The problem is this needs to do every week and every time rows of each sheet varies. I don't know how to use VBA to get this done.

    Thanks for attention and help.


  2. #2
    Super Moderator
    Join Date
    Jan 2001
    Melbourne, Victoria, Australia
    Thanked 249 Times in 231 Posts
    Is the Import workbook supposed to already exist?

    If so, where is it and what do you want to do if it already contains a worksheet with the same name? Does the Import Workbook already contain other sheets that need to remain in it?
    Andrew Lockton, Chrysalis Design, Melbourne Australia

Posting Permissions

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