I don't know if this is possible, and I know exactly what I want to happen so:
I have a "Target Sheet" in my Office 365 for each student I tutor.
Every 3 months I need to carry out a review on each learner on a worksheet "Progress Review", and want to pull data from their Target Sheet into the Progress Review.
Simple enough - open both sheets, type "=" in the cell of the destination sheet, click on source cell, hit return.
This is where I now fall down.
On the Progress Review I have a cell that I want to enter their name (as seen in the name of their Target Sheet), and I want this "name" to dynamically change in the link
So my process for creating a new Progress Review would be to open the blank version, type their name in A1 and the link in A2 changes from
='[Darryl Burge TS.xlsx]Learning Targets '!$C$14
into
='[Darryl Burgeabcdef TS.xlsx]Learning Targets '!$C$14
If I type Darryl Burgeabcdef into A1
I am wanting to be able to do this as I have a lot of random data I need to bring across, and rather than link every cell individually I want to set up every cell linked, and all I need to do is enter their name in A1 and ALL of the links are altered.
Bookmarks