Number linking

Hi all,

I need help with linking numbers. I've been tasked with doing a job planning document.

Basically, my query is:

If I have a job say called 'job 1' and this is down to be 48 hours, I then want to put hours next to people's name e.g. an 8 next to John and a 6 next to Michael, meaning 14 hours of the 48 are sorted, but I want it to then take away the 14 from the 48 on the excel document so that it's easier for people filling the form in to see how many more hours are needed to fill this job.

Can anyone help?

Thanks

Originally Posted by 6StringJazzer

Welcome to the Forum JWCOLMAN!

The problem as you describe it is very easy to solve, although the details of the solution depend on the details of what your file looks like. Do you start with a complete list of names to choose from for each job? I have provided a quick example but to get a more thorough answer you should create an Excel file with all the information you have, what you need, and what you want it to look like, then identify the specific cells that you don't know how to do.

This is spot on.

I've tried it myself but can't quite do it based on your formula. Can you have a look for me at my draft document?

I want the three 8's in the table to amend the 'Skilled men manufacture hours allowed' number of 87.

Thanks for your help!