excel automatic data entry
 

I have a database with columns headed date, name, job title, organisation
etc. I repeat some of the people as I go down my list in different dates.
What I want to know is how can I enter these same people further down in the
list and have their related information in the adjacent fields (such as the
job title, oraganisation etc.) filled in automatically without me having to
manually copy and paste the data. Could you help me please?

excel automatic data entry
 

If they are always the same people you could just use vlookup formulas from
a table. If not, you could use a find macro within a worksheet_change event
to look for the previous entry for the same person and fill in the
offsetting columns.

--
Don Guillett
SalesAid Software

"Hal" wrote in message
...
I have a database with columns headed date, name, job title, organisation
etc. I repeat some of the people as I go down my list in different dates.
What I want to know is how can I enter these same people further down in
the
list and have their related information in the adjacent fields (such as
the
job title, oraganisation etc.) filled in automatically without me having
to
manually copy and paste the data. Could you help me please?

excel automatic data entry
 

Hal

Check out Help on VLOOKUP.

Also visit Debra Dalgleish's site for examples and downloadable workbooks.

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben MS Excel MVP

On Wed, 28 Jun 2006 05:25:02 -0700, Hal wrote:

I have a database with columns headed date, name, job title, organisation
etc. I repeat some of the people as I go down my list in different dates.
What I want to know is how can I enter these same people further down in the
list and have their related information in the adjacent fields (such as the
job title, oraganisation etc.) filled in automatically without me having to
manually copy and paste the data. Could you help me please?