copy if...or transfer if

[Manos]

Dear all
i have in sheet 1 a list of 3500 acounts where i have make clear of
important and non important acounts that i need, by give them a simple color
to the specific cell.

Because there nothing to short them by color, at least i have not found
anything yet, there is any way to use a formula or a vlookup to copy let say
all the cells with yellow colour to sheet 2?

I want to split the accounts by the color i have provide to the cells. Any
ideas?

Thanks in advance
Manos

 

[Pete_UK]

Chip Pearson shows how you can sort by colour here:

http://www.cpearson.com/excel/SortByColor.htm

so this should help you in your task.

Hope this helps.

Pete

 

[Manos]

Thank you for your time,
I will tyr but i do not have the proper knowledge to vba and it seems quity
difficult.

Thanks any way
Manos