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

Chip Pearson shows how you can sort by colour he

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

so this should help you in your task.

Hope this helps.

Pete

"Manos" wrote in message
...
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

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

"Pete_UK" wrote:

Chip Pearson shows how you can sort by colour he

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

so this should help you in your task.

Hope this helps.

Pete

"Manos" wrote in message
...
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