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.
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.