+ Reply to Thread
Results 1 to 4 of 4

Number linking

  1. #1
    Registered User
    Join Date
    11-13-2019
    Location
    Leicester
    MS-Off Ver
    365
    Posts
    2

    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

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    21,128

    Re: Number linking

    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.
    Attached Files Attached Files
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    11-13-2019
    Location
    Leicester
    MS-Off Ver
    365
    Posts
    2

    Re: Number linking

    Quote Originally Posted by 6StringJazzer View Post
    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!
    Attached Files Attached Files

  4. #4
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    21,128

    Re: Number linking

    F36 has the sum of skilled hours used (or is it planned?), F37 has the horus remaining after you subtract the hours used from 87.

    (P.S. No need to quote an entire post to reply to it.)
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Linking hours worked to Job number
    By TWM16 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-19-2016, 02:39 PM
  2. Linking a Number Code to a Name
    By krutherford in forum Excel General
    Replies: 10
    Last Post: 08-04-2015, 05:14 AM
  3. Linking a number so that it brings up a name
    By wckyle in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-17-2013, 12:25 PM
  4. Linking a name to a number
    By buzza182 in forum Excel General
    Replies: 4
    Last Post: 02-12-2013, 08:09 AM
  5. Linking Number of Rows in Two Tables
    By mohmazi in forum Excel General
    Replies: 1
    Last Post: 11-10-2009, 03:42 AM
  6. linking text to a number
    By pixiesoft in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 11-13-2007, 09:56 AM
  7. Convert time to a number when linking?
    By DavidJ726 in forum Excel General
    Replies: 2
    Last Post: 05-31-2006, 01:20 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1