Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
Edit Links: Changing links on a protected worksheet | Excel Discussion (Misc queries) | |||
Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 | Links and Linking in Excel | |||
EXCEL - LINKS cannot easily get list of all links & names in book | Excel Worksheet Functions | |||
can't update links...can't find links | Excel Discussion (Misc queries) |