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"

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"

i did like you suggested and it works great. The only problem I am having
that the are three cells with descriptions and when selecting the job title
the three cells on the sheet are only pulling up the first cell. I have the
table set like this with a drop down box to choose the job type

Job title title description goal
title 1 job1 job 1 des 1 1
title 2 job1 job 1 des 2 2
title 3 job1 job 1 des 3 3
title 4 job2 job 2 des 1 4
job2 job 2 des 2 5
job2 job 2 des 3 6
job3 job 3 des 1 7
job3 job 3 des 2 8
job3 job 3 des 3 9
job4 job 4 des 1 10
job4 job 4 des 2 11
job4 job 4 des 3 12

so when changing the job title it pulls the correct "job" but only pulls
"job # des 1" .... also how would i incorporate the goal cell in this table
to appear in the column next to were the description appears.

"Pete_UK" wrote:

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"