Hi Guys,
So i have a bunch of formulas which calculate a linked workbook and im wanting to have a cell in the current workbook which you can enter the filename so that it is easily updated without going into the VBA.
=COUNTIF('C:\Users\webbth\Desktop\[South Pac Load Tracker - MAR14.xlsx]SPECIALS TEAM NZ'!$C$8:$C$1000,A4)
This is the formula for example in the cell, and i want to change [South Pac Load Tracker - MAR14.xlsx] to a cell in the workbook instead.
Bookmarks