copy if...or transfer if

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
Thu Mar 13 12:36:58 CDT 2008

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" <Manos@discussions.microsoft.com> wrote in message
news:1B36ACC6-4E51-4968-8D09-B20261FCDE50@microsoft.com...
> 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

Manos
Fri Mar 14 02:51:00 CDT 2008

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 here:
>
> http://www.cpearson.com/excel/SortByColor.htm
>
> so this should help you in your task.
>
> Hope this helps.
>
> Pete
>
> "Manos" <Manos@discussions.microsoft.com> wrote in message
> news:1B36ACC6-4E51-4968-8D09-B20261FCDE50@microsoft.com...
> > 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
>
>
>