Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Feb 2015
    Posts
    1
    Thanks
    0
    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.

    Aladin

  2. #2
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,852
    Thanks
    4
    Thanked 259 Times in 239 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
  •