Ive got one of our users who want to update values from another sheet, the issue is the other sheet in in another folder.
I know to reference another Excel document I can simply use spicify the complete folder and then the sheet, but if I have my workbook in one folder up and then into another, how can I reference that?
I would have thought I could use "'..\My Second folder\[myReferencedWorkbook.xls]Sheet1'!$C$9" (go up from my current folder and then into 'My Second folder', but it doesnt seem to work.
So for example:-
+---My First folder
¦ My First Workbook.xls
+---My Second folder
Is is possible to do referencing like this, or do I need to use the full path when moving up and down folder paths?