You can use VLOOKUP to do this. With a list of job titles in column A
and the job summary in column B of sheet1, then in sheet2 if you have
your employee name in column A and you type the job title in column B
(or better still, have a data validation pull-down so that you can
only select the job titles from sheet1), then you could have this
formula in C1:

=VLOOKUP(B1,Sheet1!A:B,2,0)

and copy this down as required.

Hope this helps.

Pete

On Aug 5, 6:05*am, Stangdriver00
wrote:
i am setting up a sheet for work and ran into a problem with setting up some
cells. *There are multiple sheets including one that has a job title which i
need to display the summary of the job on different sheet. *Simpler terms, on
sheet 1 i have a list of employees and what there job is .... each employee
has a seperate excel sheet that has more specific information along with the
information that is automatically pulled of the first sheet. *What i need is
when I change the job title of an employee on sheet on it changes his title
on his personal sheet automatically but i can't get the summary of the job. *
I have the job summaries on the first sheet but i need them to auto update
the summary on their personal sheet when i change their title on sheet1. *EX *
joe unloads trailers ...... requirements: to move fast and safely. now if i
change joe on sheet 1 to load trailers i need the requirements on his
personal excel sheet to change to check package condition and in the correct
truck. Pretty much ..... if "i type a job here" then "the job summary appears
on the individuals excel sheet"