+ Reply to Thread
Results 1 to 7 of 7

Copy range from multiple sheets, into a master sheet and moving over by variable col range

  1. #1
    Registered User
    Join Date
    08-19-2012
    Location
    somewhere
    MS-Off Ver
    Excel 2003
    Posts
    7

    Copy range from multiple sheets, into a master sheet and moving over by variable col range

    I'm trying to copy a range B3:B354 from multiple different sheets into a master sheet
    So the master sheet will open the new sheet, copy the range into B3:B354 then close the sheet
    and move to the next one then copy the range b3:354 to C3:C354 I'm having issue with getting it
    to copy the value's over.... please help Code is below.
    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 range from multiple sheets, into a master sheet and moving over by variable col r

    ThisWorkbook is the Workbook where the program resides - you'll need to change that!
    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
    08-19-2012
    Location
    somewhere
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Copy range from multiple sheets, into a master sheet and moving over by variable col r

    Change it to what? don't I need to tell it where to copy the information too?

  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 range from multiple sheets, into a master sheet and moving over by variable col r

    Try this -(I'm wrong about ThisWorkbook)

    Please Login or Register  to view this content.
    You don't need the With..End With in this case.
    Last edited by xladept; 08-23-2012 at 01:53 AM.

  5. #5
    Registered User
    Join Date
    08-19-2012
    Location
    somewhere
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Copy range from multiple sheets, into a master sheet and moving over by variable col r

    Doesn't copy anything. Doesn't toss an error either though... Though should it only target the top cell for the paste? or should it do the range again?

  6. #6
    Registered User
    Join Date
    08-19-2012
    Location
    somewhere
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Copy range from multiple sheets, into a master sheet and moving over by variable col r

    I got it to work with

    Please Login or Register  to view this content.

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

    Re: Copy range from multiple sheets, into a master sheet and moving over by variable col r

    When you use copy that way it only needs the leading cell in the range. Glad you got it to work. Surprised that my code didn't work - did you get rid of the With...End With for Thisworkbook, because, if you didn't then you'd have needed a dot before Cells i.e.
    Please Login or Register  to view this content.
    Last edited by xladept; 08-23-2012 at 01:48 PM.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1