ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Help with a sort please (https://www.excelbanter.com/excel-programming/380370-help-sort-please.html)

shhhhh

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/ =-



All times are GMT +1. The time now is 04:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com