I need help w/ data on one sheet to be used on several others
 

In Excel 2003 I have basicly a database of employee information on the first
worksheet. I would like to be able to update it in this one location and use
it on several other worksheets in the same file. Could i get some help with
macro's or something to fill in the blanks w/ specific information from this
master list.
Example: one sheet requires daily change of name and phone numbers
another sheet requires name and Identification number
another sheet requires other data listed according to the
persons name

Any help would be greatly appreciated

"Dustin" ha scritto nel messaggio


In Excel 2003 I have basicly a database of employee information on
the first worksheet. I would like to be able to update it in this
one location and use it on several other worksheets in the same file.
Could i get some help with macro's or something to fill in the blanks
w/ specific information from this master list.
Example: one sheet requires daily change of name and phone numbers
another sheet requires name and Identification number
another sheet requires other data listed according to
the persons name

Probably you could use the VLOOKUP function.
Try to search the online Excel Help (press F1).

Hoping to be helpful...

Regards
--
Franz

----------------------------------------------------------------------------------------
To reply translate from italian InVento (no capital letters)
----------------------------------------------------------------------------------------

Thanks I'll look into it!! Any thing else might be of help

"Franz" wrote:

"Dustin" ha scritto nel messaggio


In Excel 2003 I have basicly a database of employee information on
the first worksheet. I would like to be able to update it in this
one location and use it on several other worksheets in the same file.
Could i get some help with macro's or something to fill in the blanks
w/ specific information from this master list.
Example: one sheet requires daily change of name and phone numbers
another sheet requires name and Identification number
another sheet requires other data listed according to
the persons name

Probably you could use the VLOOKUP function.
Try to search the online Excel Help (press F1).

Hoping to be helpful...

Regards
--
Franz

----------------------------------------------------------------------------------------
To reply translate from italian InVento (no capital letters)
----------------------------------------------------------------------------------------