=LOOKUP(99^99,G:G)

will get the last NUMBERIC value in column G.

Does this help?


"BAKERSMAN" wrote:

I am transfering a value in one cell to another worksheet. I need it to pull
the last cell in that column with data in it. The sheet that I need to pull
from is a living document and changes daily. Can someone help?