Sorting by colors
 

I have a matrix of data in excel where they have highlighted lines with
colors. Is there any to sort this database by colors ? There are some folks
doing such a consuming time job !!

Visit www.cpearson.com, Chip has lots of stuff on colour.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Hecwill" wrote in message
...
I have a matrix of data in excel where they have highlighted lines with
colors. Is there any to sort this database by colors ? There are some
folks
doing such a consuming time job !!

Hi there,

This may help ...

http://www.ozgrid.com/VBA/Sort.htm


--
Regards,
Zack Barresse, aka firefytr


"Hecwill" wrote in message
...
I have a matrix of data in excel where they have highlighted lines with
colors. Is there any to sort this database by colors ? There are some
folks
doing such a consuming time job !!

Also http://www.xldynamic.com/source/xld....r.html#sorting

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Hecwill" wrote in message
...
I have a matrix of data in excel where they have highlighted lines with
colors. Is there any to sort this database by colors ? There are some
folks
doing such a consuming time job !!