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.
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!
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?