S
Soe
i use vlookup to get data from other workbook.
the issue is it needs to reference to that workbook several times in a
formula. The formula becomes pretty long since i hv to use absolute network
path in order to have access to different people with different mapping
drives.
i am looking for a way to shorten by using the network file as string and
keep in a cell.
I tried to use Indirect(), however, the problem is that "Indirect()"
function doesn't work when the destination workbook is not opened.
Any body have a good suggestion?
the issue is it needs to reference to that workbook several times in a
formula. The formula becomes pretty long since i hv to use absolute network
path in order to have access to different people with different mapping
drives.
i am looking for a way to shorten by using the network file as string and
keep in a cell.
I tried to use Indirect(), however, the problem is that "Indirect()"
function doesn't work when the destination workbook is not opened.
Any body have a good suggestion?