copy if...or transfer if

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Manos - 13 Mar 2008 16:40 GMT

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

Reply to this Message

Pete_UK - 13 Mar 2008 18:36 GMT

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

> Dear all
> i have in sheet 1 a list of 3500 acounts where i have make clear of
[quoted text clipped - 12 lines]
> Thanks in advance
> Manos

Reply to this Message

Manos - 14 Mar 2008 08:51 GMT

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

> Chip Pearson shows how you can sort by colour here:
>
[quoted text clipped - 22 lines]
> > Thanks in advance
> > Manos

Reply to this Message