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

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

Please Login or Register  to view this content.

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

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

Try

Please Login or Register  to view this content.

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.

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.

Hi,

Here is the attached file

Ish

Waiting for the response, i have provided the sample copy


@ Reykjavik : sorry i have already tried that

Try the attached.

HI ischopra,

Try this one,

I like AB33 solution.

Thanks Experts,

AB33 and Reykjavik both..