Need help sorting files to new locations

  • Thread starter Thread starter bourassa
  • Start date Start date
B

bourassa

ok i want to sort files to different pages, this is how it is set up


Logon cbourassa YORK tue date/time
Logoff cbourassa YORK tue date/time
Logon cbourassa YORK wed date/time
Logoff cbourassa YORK wed date/time
Logon eleighton BangKOK tue date/time
Logoff eleighton BangKOK tue date/time
Logon eleighton BangKOK wed date/time
Logoff eleighton BangKOK wed date/time

how would i sort them by user name (column b) to there own seprate pag
 
how would i sort them by user name (column b) to there own seprate page
Click to expand...

There's no way to do this automatically other than to write a VBA macro.
You can sort them manually and select the appropriate cells, or you can use
the Data/Filters command, to make the manual things easier. But I think
you really want a database software package like Access. It has much
better reporting capabilities than does Excel.
 
Back
Top