I am trying to write a formula that inputs the value of a cell that is in
another sheet. ex. =sheet1!A:7 How can I write it so it gets the value
from the last entry in the column without me specifying which cell it is.
ex. =sheet1!Athe last cell in the column that has a value in it?)

Thanks for any input