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?

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?

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?

You can use a formula to get the last value in a column if that's what you
want?

=LOOKUP(2,1/(Sheet2!C1:C65535<""),Sheet2!C1:C65535)


will return the last value entered in column C in Sheet2 with "last" meaning
that you fill down with values and if the previous value was in C3 and you
enter a new value in C7 (or any cell below C6)that value will be returned


--


Regards,


Peo Sjoblom


"Burritto" wrote in message
...
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?

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?