Forum Discussion
Links within xls
Hello. I use a simple link within a workbook, pulling data from one cell within a sheet to another sheet in the same workbook. I use two $ either side of the link (eg =SHEET1!$F$400).
I am adding rows to this sheet often. I want the link to work this out and, say I add 4 more rows into SHEET1 that feeds the link, I need the link to change to =SHEET1!$F$404. Any suggestions?
As is the link doesn't update itself and as such is pulling data from F400 rather than F404.
7 Replies
walmsb So it seems that you always want to pick-up whatever is in the last cell in column F on Sheet2. Correct? If so, the following formula will do just that:
=LOOKUP(2,1/(Sheet2!F:F<>""),Sheet2!F:F)
More about how that works in the link below:
https://exceljet.net/formula/get-value-of-last-non-empty-cell
- Hi thanks for spending the time to reply. I should have explained better, it is not the last cell. I have multiple links within the Sheet 1 and am trying to feed them through to Sheet 2. But when I add rows into Sheet 1, it fails to update the link.
walmsb Sorry! Misread the sheet names, but that doesn't matter. Can you upload a file demonstrating what you are dealing with.
