Need help sorting files to new locations

[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

 

[Jonathan Rynd]

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

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.