Is this possible ?
I have a work book with sheets that are linked as the link below
i am trying to create a master sheet so when the user changes the week number the link changes ie
Have the formula refer to a week number typed in a cell , a1 = Week 1 , when the user changes a1 to Week 2 the link changes to Week 2.
Have tried Idirect and abslolute cell refs without success ,
Can anybody help or is it a lost cause
I have a work book with sheets that are linked as the link below
=S:\RDC\RDC OUTBOUND\Shift Planner 2020-2021\Week 1\[planning tracker.xls]Sunday'!$D$3 |
Have the formula refer to a week number typed in a cell , a1 = Week 1 , when the user changes a1 to Week 2 the link changes to Week 2.
Have tried Idirect and abslolute cell refs without success ,
Can anybody help or is it a lost cause