Can you create a short cut from one sheet to a specific row on another?
Our project plans (main sheet) need to have connections to both a RAID log (supporting sheet) and / or to a RICE-FW log (supporting sheet). We do have links to cells on the main sheet for key data from the supporting sheet but we also need the ability to go to the particular supporting sheet to
a) see more detail of the issue/c AND
b) make updates to the Log that will flow back to the project plan.
Using the cell links does not allow for update of the linked cell from the main sheet