Excel links

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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