Excel links
 

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?

Excel links
 

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?

Excel links
 

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?

Excel links
 

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?

Excel links
 

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?