1. Welcome! Please take a few seconds to create your free account to post threads, make some friends, remove a few ads while surfing and much more. ClutchFans has been bringing fans together to talk Houston Sports since 1996. Join us!

Need MS Excel command help

Discussion in 'BBS Hangout' started by Behad, Nov 17, 2006.

  1. Behad

    Behad Member

    Joined:
    Feb 20, 1999
    Messages:
    12,358
    Likes Received:
    193
    Calling on the power of the BBS:

    I'm working on a new spreadsheet my boss wants to see. My data page is importing values from another program on an hourly basis. Consequently, the last value in a column is constantly changing...by changing, I mean adding a row to the column with new information.

    Now then, this value is linked to another cell. How do I tell the cell to look at the newly added row (i.e., the bottom of the list). I know there is a command for this, but I can't find it anywhere.
     
  2. Lil Pun

    Lil Pun Member

    Joined:
    Oct 6, 1999
    Messages:
    34,143
    Likes Received:
    1,038
    Are you doing this through VBA or Excel commands?
     
  3. Behad

    Behad Member

    Joined:
    Feb 20, 1999
    Messages:
    12,358
    Likes Received:
    193
    Excel
     
  4. Behad

    Behad Member

    Joined:
    Feb 20, 1999
    Messages:
    12,358
    Likes Received:
    193
    It's a VLOOKUP command, defined by the leftmost column range (time, in this case).

    Thanks to all those who didn't help me with this! :p :)
     
  5. Lil Pun

    Lil Pun Member

    Joined:
    Oct 6, 1999
    Messages:
    34,143
    Likes Received:
    1,038
    Sorry. I just got back to my PC. I would've tried since I am certified in Excel. It's amazing how far I've come huh?
     
  6. Behad

    Behad Member

    Joined:
    Feb 20, 1999
    Messages:
    12,358
    Likes Received:
    193
    Simply Amazing!! :p


    I'm not certified in Excel, but I figured it out anyway. thanks for trying.
     

Share This Page