+ Reply to Thread
Results 1 to 4 of 4

Copy same range from multiple sheets and paste into one sheet of active workbook

  1. #1
    Registered User
    Join Date
    03-21-2010
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    90

    Copy same range from multiple sheets and paste into one sheet of active workbook

    I am trying to have the code to open 3 files, select sheet 2 in each file, copy, and paste into one sheet of the active workbook. On the one worksheet of the active workbook, I want to go to the next empty row and paste from each of the 3 files.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Copy same range from multiple sheets and paste into one sheet of active workbook

    Maybe:

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    03-21-2010
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    90

    Re: Copy same range from multiple sheets and paste into one sheet of active workbook

    Thanks for the help. However, your code gave me the same results.

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Copy same range from multiple sheets and paste into one sheet of active workbook

    You're welcome! This
    Please Login or Register  to view this content.
    didn't get the next empty row???

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy Cell Range From Previous Sheet and Paste to Active Sheet
    By jtal in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-01-2013, 03:26 PM
  2. [SOLVED] copy range from multiple sheets and paste to one sheet
    By David_Hiss in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-05-2013, 09:48 PM
  3. [SOLVED] Macro to Copy range from multiple sheets and paste in new Workbook
    By cameron.beyers in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-03-2012, 01:00 PM
  4. Copy cell range from active sheet to all remaining sheets
    By jpruffle in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-08-2011, 04:09 PM
  5. Copy from active sheet and paste into new sheet using info from cell in active
    By Ingve in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-23-2006, 06:00 PM

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