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"