Sheet 1 (a sign up sheet) looks like this:
A_______B________C__________D__________E
8:00__B. Jones__Fred Fox__Fred Farel_R McDow
8:30__Al Smith__Mike Brown___________Ti Smith
9:00____________Mary Allyn
I would like sheet 2 to be an alpa list:
A________B
9:00___Mary Allyn
8:30___Mike Brown
8:00___Fred Farel
8:00___Fred Fox
8:00___B. Jones
8:00___R McDow
8:30___Al Smith
8:30___Ti Smith
(The lines ____ are just there to space things out for this posting.)
This type of listing has probably been done thousands of times, by thousands of people.
However, I am having problems with things like sorting the blank spaces and generally staying out of trouble. Is there some sort of easy macro that can make the process "automatic" rather than a series of tedious excel steps? My actual listing can have up to 128 names per day, luckily there are lots of blank slots.
Thanks for any help/advice.
Mike
This message was edited by MikSwor on 2002-03-26 08:04
A_______B________C__________D__________E
8:00__B. Jones__Fred Fox__Fred Farel_R McDow
8:30__Al Smith__Mike Brown___________Ti Smith
9:00____________Mary Allyn
I would like sheet 2 to be an alpa list:
A________B
9:00___Mary Allyn
8:30___Mike Brown
8:00___Fred Farel
8:00___Fred Fox
8:00___B. Jones
8:00___R McDow
8:30___Al Smith
8:30___Ti Smith
(The lines ____ are just there to space things out for this posting.)
This type of listing has probably been done thousands of times, by thousands of people.
However, I am having problems with things like sorting the blank spaces and generally staying out of trouble. Is there some sort of easy macro that can make the process "automatic" rather than a series of tedious excel steps? My actual listing can have up to 128 names per day, luckily there are lots of blank slots.
Thanks for any help/advice.
Mike
This message was edited by MikSwor on 2002-03-26 08:04