Thanks, worked like a charm. I fiddled a bit with the code to make it
do all sheets in one go.
The example was a great help.
Joost
--
--
Some important links for excel users:
1. Follow us in TWITTER for tips tricks a
recorded the "sort" section.
You may wish to record your own "sort" for the final product
so you get the order you're looking for.
Paul
- Original Message
> From: Joost
> To: MS EXCEL AND VBA MACROS
> Sent: Tue, January 12, 2010 11:16:49 AM
> Subject:
Hi,
For handling in another program I've been asked to convert our excel-
student-roster into a list. Currently our roster is a simple grid with
the hours on one axis and the students on the other:
Hour | StudentA | StudentB | etc.
H1| Course A | Course B |
H2| Course B | Course C |
H3
