I am trying to copy data from 7 different sheets (located under same workbook) to summary sheet.
I want to copy selected lines
it should copy entire row
I have prepared below code but it is throwing error and other thing is its not completely dynamic
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
Secondly, this program is throwing an error in the beginning " Run-time Error '1004': Application defined or object-defined error.
any help is appreciated