Hello everyone... I'm new to making macros and would appreciate any hel
given for the questions / problems below.

In one worksheet (the only worksheet so far created), I have man
columns with different data. One column is called School, anothe
Name, another Semester, another Course, and last is Grade.

I want to create a macro that will look in this one worksheet and:

- create a new worksheet for every school with the name of the schoo
as the worksheet name
In every one of the School worksheets I would like:
- Name of the student written out once (would require merging due t
multiple courses taken by the student), followed by courses he ha
taken in the column to the right of it.
- the courses are listed next to the student and would need to b
seperated by Semester (which would go on top right of the exce
worksheet)


I would love to have a macro to do this all automatically... Thank
for any help that you guys can provide

--
NeedsExcelHelp
-----------------------------------------------------------------------
NeedsExcelHelp4's Profile: http://www.excelforum.com/member.php...fo&userid=3189
View this thread: http://www.excelforum.com/showthread.php?threadid=51629