Hello,
My manager asked me to prepare a margin calculation sheet that contains confidential unit costs and limit its distribution to senior management only.
The idea is to create an excel file where the cost is read via a Vlookup formula reading for a local file in drive C.
So when a senior manager sends the file to a normal employee for example, this normal employee will open the file, see the price but never sees the cost or margin because they simply don't have the cost file saved in their drive C.
I tried doing so but creating a MACRO that reads from a local file, it worked, but then I sent it to my colleague for testing, and unfortunately the cost appeared in his version although he doesn't have the cost file.
The weird part here is that the formula in his excel version is shown as if reading from his local file that didn't really exist:
=IF(E4="EUR",IFERROR(VLOOKUP(B15,'C:\SC\[Cost_eff_2017USD.xlsx]Sheet1'!$A:$D,3,FALSE),0),IFERROR(VLOOKUP(B15,'C:\SC\[Cost_eff_2017USD.xlsx]Sheet1'!$A:$D,4,FALSE),0))
My question is, how can I amend this Macro in a way that whenever it's sent to someone who doesn't have the cost file saved in his drive C, he will simply get the cost and margin columns empty..
Appreciate your help!
My manager asked me to prepare a margin calculation sheet that contains confidential unit costs and limit its distribution to senior management only.
The idea is to create an excel file where the cost is read via a Vlookup formula reading for a local file in drive C.
So when a senior manager sends the file to a normal employee for example, this normal employee will open the file, see the price but never sees the cost or margin because they simply don't have the cost file saved in their drive C.
I tried doing so but creating a MACRO that reads from a local file, it worked, but then I sent it to my colleague for testing, and unfortunately the cost appeared in his version although he doesn't have the cost file.
The weird part here is that the formula in his excel version is shown as if reading from his local file that didn't really exist:
=IF(E4="EUR",IFERROR(VLOOKUP(B15,'C:\SC\[Cost_eff_2017USD.xlsx]Sheet1'!$A:$D,3,FALSE),0),IFERROR(VLOOKUP(B15,'C:\SC\[Cost_eff_2017USD.xlsx]Sheet1'!$A:$D,4,FALSE),0))
My question is, how can I amend this Macro in a way that whenever it's sent to someone who doesn't have the cost file saved in his drive C, he will simply get the cost and margin columns empty..
Appreciate your help!
