excel automatic data entry

H

Hal

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?
 
D

Don Guillett

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.
 
Top