PDA

View Full Version : automatic sorting



maksinx
03-15-2007, 01:25 PM
gello there,
i have a file where a command button runs a macro and collects data from sheet called jun 2007 and copies to sheet called report, while it is copying there are two different sets of data type,
one highligted white and the other one highlighted blue,

is there any way to sort the two datas individually,white rows needs to be sorted according to column called eta,
and blue ones needs to be sorted according to eta as well in ascending order.

if you need further information pls contact me

thanks in advance
i have attached the file.

austenr
03-15-2007, 04:01 PM
Try this link. You should be able to modify it to do what you want.

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