How to Create a Macro that automatically copies the cells in this range, when typing.

can you post an example sheet?

Originally Posted by GeneralDisarray

can you post an example sheet?

Have upload a zip file of the excel 2003 file

Originally Posted by skin.uk1

Have upload a zip file of the excel 2003 file

Yes at the top of the page!

Ok, what is the input sheet? i see you want the input copied into theses Named sheets “Volunteer Info”, “Communications”, Volunteer Spoken Languages”, “EOPS Monitors”

But, where are you actually typing the input? Also, you only want the B-D columns copied over right?

Originally Posted by GeneralDisarray

Ok, what is the input sheet? i see you want the input copied into theses Named sheets “Volunteer Info”, “Communications”, Volunteer Spoken Languages”, “EOPS Monitors”

But, where are you actually typing the input? Also, you only want the B-D columns copied over right?

Actually the typing input is on the "Volunteer info" Sheet"
Click B9 the drop down list appears, then you choose one of 3 ("GIR", "LHS","LHW").
In C9 you enter input First name, D9 enter input Surname.
When you input these fields, I want it copied auto on the other sheets into the same cells etc.

i've tried a couple of responses here....but keep rambling on. looks like what you want is a full blown database. keeping the tabs you've presented straight within excel would be a pain in the **** -- you can easily replicate the b-d columns...but that would be a bad idea.

There is no connection between the tables with the other columns, so one sort on the "volunteer info" page would blow away anything you have entered. i'm sure you can design in controls to protect the sheets...but seems like you would be better served designing a form to populate an access database properly designed to allow you to pull queries for the other tabs.

or, just enter alllllll the information in one really large table on the volunteer info tab and have a bunch of vlookup statements to present it in smaller chunks on the other tabs. Sounds really lame - but a sort wouldn't blow it away.

Originally Posted by GeneralDisarray

i've tried a couple of responses here....but keep rambling on. looks like what you want is a full blown database. keeping the tabs you've presented straight within excel would be a pain in the **** -- you can easily replicate the b-d columns...but that would be a bad idea.

There is no connection between the tables with the other columns, so one sort on the "volunteer info" page would blow away anything you have entered. i'm sure you can design in controls to protect the sheets...but seems like you would be better served designing a form to populate an access database properly designed to allow you to pull queries for the other tabs.

or, just enter alllllll the information in one really large table on the volunteer info tab and have a bunch of vlookup statements to present it in smaller chunks on the other tabs. Sounds really lame - but a sort wouldn't blow it away.

I don't want create a database, just need some Macro coding?
Can anybody help, can the site gurus help me please