J
Jako
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
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