Filter,copy,paste in excel

[vijay2482]

Hi everybody,
First of all, thanks to all those who help me in my previous posts.

I'm working on an excel that contains a macro to color the cells based on the columnS.
This part of the code works perfectly.
Now I need another macro, that could filter the rows based on each color in different columns,copy the filtered rows from the current workshhet and paste it in a destination worksheet.
The destination workbook contains different worksheets for rows filtered based on the color.
eg:
The rows with orange color(color 44) has to be pasted in the Due.Amt worksheet of the destination workbook.
The rows with green color(color 35) has to be pasted in the Expenses worksheet of the destination workbook.
and so on for the different colors(the coloumn name in the source worksheet and the worksheet name in the destination workbook will be the same, so the paste shoud be done respectively).
The destination worksheet may/may not contain datas, in that case, the paste as to be done in the next available empty row.
The previous datas should not be deleted/overwritten in the destination worksheet.

Not able to attach a workbook here.

Any help and suggestions will be helpful.

 

[Weaver]

First off, I'd suggest you do your filtering based on the criteria used to create the colour coding, rather than the colour itself.

After that, a good trawl of this message board ought to find several posts detailing how to filter and split data onto other worksheets/books, since it's a question that gets asked a lot.