Forum Discussion
Links to changing file names
I am trying to create a simple way to have a link within a spreadsheet where I "enter" the linked spreadsheet name and location in 1 location - Here is the scenario...... I have a file called June...
Hi brad_tay64 ,
You can play with this a little to adjust it to your needs. In the screenshot attached, if I change the filename to "sourceV2" in explorer and in cell D1 my value in cell A1 will pick up the new workbook.
Bennadeau Thank you - works like a charm. The only thing you need to make sure of is that the file you are linking to is open. I appreciate your quick response.
