Hello all,

Im creating cell references to other worksheets and I am ending up with formulas like this ='K:\J55000\J55400 to J55499\Results\[1_fender.csv]1_fender'!A1 . This is referring to a specific folder on the hard drive. How can I change this so that it always refer to the folder in which my 'main' workbook is saved? I want to do this so that I can copy and paste the folder in different locations and still be able to use the spreadsheet.


Thanks in advance

Lovi