Insert new row automatically

F

Fellow

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert new rows 3
format new rows 2
Automatically insert new rows 2
make excel copy a row and automatically insert new rows 2
Determine best way to sum 4
Automatically insert a new row when certain number is entered in c 1
Automatically add one row 3
Formula changes as new data is entered... 4

Top