On the sheet that references your "BackSheet" try something like this:

=LOOKUP(2,1/(1-ISBLANK(BackSheet!B1:B500)),BackSheet!B1:B500)

Assuming that the sheet you want to pull the data from is called "BackSheet"
and the range you are working in is B1:B500. Just change the variables to
whatever you are actually using.


"Burritto" wrote:

RayportingMonkey, THANKS for the reply....Care to try again?.....

I don't think this will work. I have several areas that I inspect on a
regular basis. After I inspect the area, I update the "back" sheets w/date of
inspection and caracteristics found. Each time I update the "back" sheets, I
must either manually put the data in sheet 1, or change the link to the "new"
row w/updated data. Can XL change the link automatically to the last row that
is populated w/data?

"RayportingMonkey" wrote:

Asuming your first sheet is Sheet1 and you are updating information in cell
A1, then the formula to link to that from another sheet, such as Sheet2 would
be:

=Sheet1!A1

Just repace "Sheet1" with whatever your sheet is named and the cell
reference of A1 to what ever cell or range is applicable.


"Burritto" wrote:

I have a workbook that has several worksheets. I manually update the info in
the back worksheets and have links in certain cells to update the info on the
first worksheet. Is there a way to for the link to update to the latest data
I put in the back sheets so that the link changes to the next line once I
populate it w/data?