Making automatic headers in a macro

**Helemaal Dave** · 10-22-2007, 07:49 AM

hey,

I've been asked by my company to make an excel file for all the phone numbers from the company.
there were some requests:

it must be sorted on 6 different sorts (name, surname, department etc.)
there must be headers from each department above the sections
everything must be done with 1 macro

this may sound a bit confusing, but I can't reveal any data from the company so I'll try to be as exact as possible:

sheets:

Phonenumbers
Department1
Department2
Department3
Department4
Name
Surname

Every bit of information is in 'Phonenumbers', as soon as they edit Phonenumbers and execute the Macro, everything will be selected and put in the right sheet (department 1, 2, 3, 4, name and surname) leaving Phonenumbers untouched of course.

I've come this far to spread them all to the correct sheets by using macro's and submitting them into one macro.
But for the Sheets Name and Surname, there need to be headers from the departments above each Department.
This is easily done by doing so while recording a macro, BUT what happens when a person gets added to the Phonelist?
Excel remembers the row you're putting the header in, but if a person is added, that header must be placed one lower!
This is the problem I've been facing and I hope one of you has a solution.

(hereby some information that could be usefull)
http://img516.imageshack.us/img516/4954/agafaqw7.jpg

Kind regards,

Helemaal Dave