+ Reply to Thread
Results 1 to 13 of 13

Copy from different sheets and paste to summary sheet

  1. #1
    Registered User
    Join Date
    05-20-2011
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    26

    Copy from different sheets and paste to summary sheet

    Hello experts,

    I am trying to copy data from 7 different sheets (located under same workbook) to summary sheet.

    Problem:

    I want to copy selected lines
    it should copy entire row

    Solution:

    I have prepared below code but it is throwing error and other thing is its not completely dynamic

    Please Login or Register  to view this content.

    The format for the sheets are same with headings as well, i am trying to filter based on the yellow color then copying and pasting to the summary sheet, can somebody tell me the way to select/Copy filtered highlighted rows dynamically? the below code is hard coded

    Rows("12:13").Select


    Secondly, this program is throwing an error in the beginning " Run-time Error '1004': Application defined or object-defined error.

    any help is appreciated

    ish

  2. #2
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Copy from different sheets and paste to summary sheet

    Untested code. If this does not work, you need to attach your sample.

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    05-20-2011
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Copy from different sheets and paste to summary sheet

    Hi there,

    thanks for the reply but it is throwring this error on this line :
    Please Login or Register  to view this content.
    run time Error: 438

    Object doesn't support this property or method..

    please help

  4. #4
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Copy from different sheets and paste to summary sheet

    I know but need to see a sample. Please attach one!

  5. #5
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Copy from different sheets and paste to summary sheet

    Try

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    05-20-2011
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Copy from different sheets and paste to summary sheet

    Hi,

    It goes to all the sheets but doesn't copy the content.. something wrong in here

    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    08-26-2009
    Location
    Iceland
    MS-Off Ver
    Excel 365, Windows 10
    Posts
    108

    Re: Copy from different sheets and paste to summary sheet

    Sample would help.

    I use macro, and put many macros together in the end.

    If I understand your problem correctly, try use
    1. shift+end+arrow down
    2. copy
    3. go to top of your combined sheet
    4. press shift and than end, then arrow down
    5. now you are in row belowe your last row, press paste.
    6. repeat as needed

    Good luck.

  8. #8
    Registered User
    Join Date
    05-20-2011
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Copy from different sheets and paste to summary sheet

    Hi,

    Here is the attached file

    Ish
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    05-20-2011
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Copy from different sheets and paste to summary sheet

    Waiting for the response, i have provided the sample copy


    @ Reykjavik : sorry i have already tried that

  10. #10
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Copy from different sheets and paste to summary sheet

    Try the attached.
    Attached Files Attached Files

  11. #11
    Forum Contributor
    Join Date
    08-26-2009
    Location
    Iceland
    MS-Off Ver
    Excel 365, Windows 10
    Posts
    108

    Re: Copy from different sheets and paste to summary sheet

    HI ischopra,

    Try this one,
    Attached Files Attached Files

  12. #12
    Forum Contributor
    Join Date
    08-26-2009
    Location
    Iceland
    MS-Off Ver
    Excel 365, Windows 10
    Posts
    108

    Re: Copy from different sheets and paste to summary sheet

    I like AB33 solution.

  13. #13
    Registered User
    Join Date
    05-20-2011
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Copy from different sheets and paste to summary sheet

    Thanks Experts,

    AB33 and Reykjavik both..

+ 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