Need help ASAP (Sort chronologically)

  • Thread starter Thread starter Ben
  • Start date Start date
B

Ben

What I mean by sorting chronologically is sorting by the
time that I entered the text. The situation is that I am
making a spreadsheet for an employer, listing the
different courses that each teacher can type. There's a
teachers column, and then a column for every course that
they can teach. Every once in a while, I'd sort the data
in the teacher column alphabetically, not thinking about
the fact that this would make the data next to it be out
of order. What I need to know how to do is sort a column
chronologically by the TIME THAT I ENTERED THE DATA.
Thank you!
 
You have to have a field that records the time you did it - Doesn't matter
whether it be via VBA or just manually entered using CTRL+SHIFT+; but somewhere
you need to record that info. Then just sort on that column.

That having been said, do you mean you are entering data like this:-

Name Course
Teacher1 CrsA
CrsB
CrsC
CrsD
CrsE
Teacher2 CrsA
CrsB
CrsC
CrsD
CrsE

because if so, then that is BAD!!! Stick to a database format and put the
teacher name in against every entry and you will then be able to use Subtotals,
or Pivot tables or sorting etc. Don't give yourself a real headache by doing it
this way. You then also don't need to do what you asked.
 
I'm entering data so that the worksheet looks like this...

|Teacher| |Course 1| |Course 2| |Course 3|
|NAME OF TEACHER||NAME OF COURSE|| "" |

That might be messy, the solid lines indicate a row, and
the text directly under "teacher" and "course 1" is in the
same column. All of that said, is there anyway I can fix
my error without having to start over?
 
Ben

Use a helper column(to the left of Teacher column?)

Enter number 1 in first row. Right-click and drag down to bottom of data
range. Release and choose "Fill series".

When your do a sort make sure all columns are selected before you sort. This
keeps them together by rows.

To revert to original, select all columns and sort on the numbers column.

Gord Dibben Excel MVP
 
Back
Top