+ Reply to Thread
Results 1 to 8 of 8

Copy the same range from 6 sheets to a Result Sheet

  1. #1
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 2019
    Posts
    486

    Copy the same range from 6 sheets to a Result Sheet

    I have 6 static tabs and an additional one Result.
    In the Result Sheet i need to copy the same range from all 6 sheets e.x Range("D14:I14")

    WHat i did until now, is not ok as i have something like this from my macro:
    JOhn D D Johnny L Coker A House P Joe DMan

    #REF! #REF! #REF! #REF! #REF! #REF! #REF!

    #REF! #REF! #REF! #REF! #REF! #REF! #REF!

    #REF! #REF! #REF! #REF! #REF! #REF! #REF!

    #REF! #REF! #REF! #REF! #REF! #REF! #REF!

    #REF! #REF! #REF! #REF! #REF! #REF! #REF!

    #REF! #REF! #REF! #REF! #REF! #REF! #REF!

    #REF! #REF! #REF! #REF! #REF! #REF! #REF!

    #REF! #REF! #REF! #REF! #REF! #REF! #REF!

    If someone could help me, i would owe you a lot!

    Please Login or Register  to view this content.
    I should have only 6 lines, but i got 8 :D and one extra column
    Please consider:
    Be polite. Thank those who have helped you.
    Click the star icon in the lower left part of the contributor's post and add Reputation. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Posting code between tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

  2. #2
    Forum Expert
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,513

    Re: Copy the same range from 6 sheets to a Result Sheet

    Please Login or Register  to view this content.
    "Presh Star Who has help you *For Add Reputation!! And mark case as Solve"

  3. #3
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 2019
    Posts
    486

    Re: Copy the same range from 6 sheets to a Result Sheet

    it gives me runtime 1004. Subscription out of range. Do you know why?

  4. #4
    Forum Expert
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,513
    Quote Originally Posted by IonutC View Post
    it gives me runtime 1004. Subscription out of range. Do you know why?
    Not to find range
    Try again
    Please Login or Register  to view this content.
    Last edited by daboho; 11-02-2018 at 07:03 AM.

  5. #5
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 2019
    Posts
    486

    Re: Copy the same range from 6 sheets to a Result Sheet

    gaved me unqualified reference on ws.range==>doesnt like the dot before .cells

    I've updated my macro file. please see attached my workbook

    Thank you!
    Attached Files Attached Files

  6. #6
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 2019
    Posts
    486

    Re: Copy the same range from 6 sheets to a Result Sheet

    i have removed that ws from the front of the range and is working, but is not pasting any values, just because is running without pasting values out there...

  7. #7
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,835

    Re: Copy the same range from 6 sheets to a Result Sheet

    Try
    Please Login or Register  to view this content.

  8. #8
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 2019
    Posts
    486

    Re: Copy the same range from 6 sheets to a Result Sheet

    Thank you Jindon! That did the trick!

+ 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. Dynamic Copy Range All Sheets to One Sheet
    By jonathann3891 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-29-2015, 08:26 AM
  2. Compare 2 sheets and copy new records into result sheet
    By Chandrahaas in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-05-2014, 04:28 AM
  3. [SOLVED] Copy and Paste sheet into a range of sheets from list
    By adw223 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-20-2013, 01:11 PM
  4. [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
  5. Look through a range for a value and copy result to a new sheet
    By Martijn79 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-15-2013, 07:40 AM
  6. [SOLVED] Copy range from multiple sheets, into a master sheet and moving over by variable col range
    By g1eagle in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-23-2012, 01:36 PM
  7. match A3 to range then copy result into another sheet..
    By hot in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-27-2012, 07:59 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