I am not sure if this is possible but here goes.

I have 3 worksheets "Raw", "Clear" and "Hold" .

On "Raw" there are rows of data, some of them are in Red text, some i
Blue, but most are in black.

What i need to do is if the text colour is red i want to copy the whol
row (A:H) and paste it onto the "Hold" worksheet. The "Hold " workshee
though will already have data on it, so i need to paste the row to th
next empty cell down.

I need to do the same as the red text but this time if the text colou
is blue i want to paste it onto the "Clear" worksheet.

I also want to keep the Format of the cell values as some are dates.

Any help appreciated

--
Message posted from http://www.ExcelForum.com