Hello everyone,
I have a question about linking excel files together. I know there is a way to do an = and reference another excel document, so that whenever that other excel is updated it would update both documents.
I believe it is under data, connections then.... That is far as I can get. This is an example of one that works, but I am not sure how it was done.
'\\Usnt42\psf\Finance\Current Year - P, S & F Documents\Marketing Managers Input\Combined Sales Estimates, Geo Change\[LAA Sales Est - PS&F.xls]Volume'!CT67*1000*
In this work book it shows that it is connected/linked with the finance folder (Excel Document).
Any help on this would be greatly appreciated. Thank you for your time and support.
I have a question about linking excel files together. I know there is a way to do an = and reference another excel document, so that whenever that other excel is updated it would update both documents.
I believe it is under data, connections then.... That is far as I can get. This is an example of one that works, but I am not sure how it was done.
'\\Usnt42\psf\Finance\Current Year - P, S & F Documents\Marketing Managers Input\Combined Sales Estimates, Geo Change\[LAA Sales Est - PS&F.xls]Volume'!CT67*1000*
In this work book it shows that it is connected/linked with the finance folder (Excel Document).
Any help on this would be greatly appreciated. Thank you for your time and support.