Auto fill of columns

[Guest]

I'm trying to create a spreadsheet where I can enter a person's name and it
will automatically enter their department and charge number. Is there any
way to do this?
Thanks.

 

[John Vinson]

I'm trying to create a spreadsheet where I can enter a person's name and it
will automatically enter their department and charge number. Is there any
way to do this?
Thanks.

Are you trying to create a Spreadsheet in Microsoft Excel? Or a Table,
in Microsoft Access? They are different programs with different
requirements.

If you are using Access, note that you should NOT copy department and
charge number from one table and store it redundantly in a different
table. Instead, you can create a Query to link the personnel table
(with these fields) to some other table. Also, you should not be
working directly in table datasheet view; that's just for debugging.
Use a Form instead.

John W. Vinson[MVP]