View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
shhhhh shhhhh is offline
external usenet poster
 
Posts: 11
Default Help with a sort please

I have a sheet that I would like to sort. It has the Date in column A, and a Start Time in column B, with another 5 columns of data. It is for multiple employees, so what I would like to do is sort it by date, then start, but limit the sort to be by them employee. Column F has a count that changes when the employee does.

something along the lines of

do sort until sortcount = employeenumber
sort on column a, then column b as long as sortcount = cell f,x (x is employeenumber)
sortcount=sortcount + 1
loop

I hope that I was able to explain this.
Thanks.


--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://www.shemes.com/ =-