Forum Discussion

walmsb's avatar
walmsb
Copper Contributor
Aug 18, 2021

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 addin...
excel
walmsb's avatar
walmsb
Copper Contributor
Aug 18, 2021
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.
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Aug 18, 2021

walmsb Sorry! Misread the sheet names, but that doesn't matter. Can you upload a file demonstrating what you are dealing with.

    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Aug 18, 2021

      walmsbThanks! Now explain what you do with it. You linked two cells in Sheet2 to cells in Sheet1, column E based on a matching description in column A on both sheets. The Asset Manager in Sheet 2 is now linked to a date for the first Asset Manager in Sheet1. Should you want to have that automatically updated to the date belonging to the last "Asset Manager" in Sheet1, the one in row 14?

       

      If that is the case, see attached. Sheet2, column D contains a similar formula as the one I suggested earlier.

      • walmsb's avatar
        walmsb
        Copper Contributor
        Aug 18, 2021

        Riny_van_Eekelen

        thank you. wow that is a seriously long link. The sheet I sent you was probably a bit confusing, I have attached a better one here. I am adding rows into sheet 1, and want sheet 2 to always include the date that corresponds to Sheet 1. Eg when I add a row below Charlie in Sheet 1, I always want the Freddie date to link in Sheet 2 (hence link to C7). Will the long link you suggested do this? Thank you for your help.... v appreciative 

Resources