the table I am using has heading row and in column A 10 category headings. ie.


A B C D E F
G ....
1 NAME SUBURB CONTACTS TYPE LINKS OUTCOMES ....
2 EMPLOYER
3 INDUSTRY
4 SCHOOLS
5 REFERRAL
6 SERVICES
7 GROUPS
8 TRAINING
9 COMMUNITY
10 MEDIA
11 OTHER

I wanted to be able to automatically add a new row under each category as
each new contact is added (ie. if a new employer when data is added in B2 a
new row will be added '3' under the EMPLOYERS category ready for the next
entry). I wanted this feature available seperately for each of the categories
in 'A' (ie. A new row added for INDUSTRY etc).

Thanks for your help,
Kind regards

Look at user forms in vba

"Fellow" wrote:

the table I am using has heading row and in column A 10 category headings. ie.


A B C D E F
G ....
1 NAME SUBURB CONTACTS TYPE LINKS OUTCOMES ....
2 EMPLOYER
3 INDUSTRY
4 SCHOOLS
5 REFERRAL
6 SERVICES
7 GROUPS
8 TRAINING
9 COMMUNITY
10 MEDIA
11 OTHER

I wanted to be able to automatically add a new row under each category as
each new contact is added (ie. if a new employer when data is added in B2 a
new row will be added '3' under the EMPLOYERS category ready for the next
entry). I wanted this feature available seperately for each of the categories
in 'A' (ie. A new row added for INDUSTRY etc).

Thanks for your help,
Kind regards