Transferring most current data from table to another spreadsheet

[LinkC]

I record new data at the bottom of a table every day. I'm looking for a way to efficiently (automatically?) plug the latest data into an existing spreadsheet.

I'd prefer to have it automatic as new data is entered, but I could run a macro or click in a "trigger" cell, if need be. Several other people use the data table so I cannot alter its appearance.

I've attached a VERY simplified example file. If this is a stupid newbie question, feel free to laugh at me behind my back...

[NBVC]

For Stock 1: =LOOKUP(9.999999E+307,Sheet1!B:B)

Change the column Range for the other Stocks.

[LinkC]

You're good! And fast.

I just plugged the LOOKUP into the "real" sheet and it works flawlessly.

Thank you SO much!

(And my c/p frazzled fingers thank you too!)

Solved

[LinkC]

OK, now that I've played with it, I GOTTA know...

What the heck is the "value" statement (9.999999E+307) telling it to look for?

[NBVC]

9.99999999e+307 is the largest number Excel recognizes...

The Lookup() function looks for the last number in a range that is smaller than or equal to the lookup value...

So, almost surely the last number in your range is less that 9.999999e+307, so it captures that for the result of the LOOKUP() formula.

[LinkC]

Ah! That makes sense.

(And if any ONE of my stocks ever hits a value higher than that, I won't be slaving away at a keyboard...that's for sure!)