Copying Rows on Text Colour?
 

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

Copying Rows on Text Colour?
 

something like
for each c in selection
if c.interior.colorindex=3 then c.copy etc
next

--
Don Guillett
SalesAid Software

"Jako " wrote in message
...
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 in
Blue, but most are in black.

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

I need to do the same as the red text but this time if the text colour
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/