Hi,
It is probably a very simple solution to this problem. Have tried to search for it, but haven't found any, and is hoping that someone is able to help with the problem
I have this formula:
=IF(A2&B2="";;SUMPRODUCT(1*('G:\Shared\3_HMS and Kvalitet (QC)\3.5_DM\[Dokumentkontroll.xlsm]Registration'!CI:CI=A2&B2))+SUMPRODUCT(1*('G:\Shared\3_HMS and Kvalitet (QC)\3.5_DM\[Dokumentkontroll.xlsm]Returned documents'!P:P=A2&B2)))
What i want to do is to change the first part of the workbook reference, this part:
G:\Shared\3_HMS and Kvalitet (QC)\3.5_DM\
With text that is stored in a cell, say L2. This way i will be able to make the workbook reference dynamic, so i don't have to repair broken links, when someone desides to change a folder name.
Any help will be appreciated
Bookmarks