GraYmOnD0808
New Member
- Joined
- Jan 15, 2021
- Messages
- 2
- Office Version
- 2016
- 2010
- Platform
- Windows
Hi Everyone,
This is one i have tried for ages at but have never managed to crack. It would be so useful to me if i could finally get it.
Essentially, for example based on the below image, i want to use column I to form part of the file name of the link i want to reference. So my formula for instance would read
='K:\Prod\Pick lists\ALDI\Aldi Salad (PTZ)\["I4".xlsm]ALDI Order'!$P$8
Is there a way to incorporate a cell into the link location? This way i can just drag my formulas down each day and have the cells populate without using a find and replace like i do now.
Thanks
Jimmy
This is one i have tried for ages at but have never managed to crack. It would be so useful to me if i could finally get it.
Essentially, for example based on the below image, i want to use column I to form part of the file name of the link i want to reference. So my formula for instance would read
='K:\Prod\Pick lists\ALDI\Aldi Salad (PTZ)\["I4".xlsm]ALDI Order'!$P$8
Is there a way to incorporate a cell into the link location? This way i can just drag my formulas down each day and have the cells populate without using a find and replace like i do now.
Thanks
Jimmy