Results 1 to 7 of 7

Help with linking cells ..

Threaded View

  1. #1
    Registered User
    Join Date
    03-02-2012
    Location
    Halifax, NS
    MS-Off Ver
    Excel 2010
    Posts
    20

    Help with linking cells ..

    Hello

    I have an excel sheet (version 2010) that has a few sections that you can add in names (via drop down box). I also have a spot where i want these names to populate - on a second sheet.

    Ex
    Truck #1:
    1. _____
    2. _____
    3. _____
    4. _____
    5.______

    Truck #2:
    1. _____
    2. _____
    3. _____
    4. _____
    5.______

    Truck #3
    1. _____
    2. _____
    3. _____
    4. _____
    5.______

    Truck #4
    1. _____
    2. _____
    3. _____
    4. _____
    5.______
    6.______
    7.______
    8.______

    My problem is when I refer to the first worksheet from the second worksheet it shows blanks where there are no names. For example i want the second sheet [ LOC ] to show the names that appear under Truck #1, #2, #3, #4 - but truck #1 may not always have names under it?

    Sample Excel file attached -




    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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