Excel links

B

Burritto

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?
 
R

RayportingMonkey

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.
 
B

Burritto

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?
 
P

Peo Sjoblom

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
 
R

RayportingMonkey

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.
 
Top