Using data on a server
Hi,
I am trying to create a worksheet on a person's desktop that can pull values
from a worksheet on a server.
The original formula referenced a cell on a different sheet in the same
workbook like so:
=SUM(IF('[CDMA_Status.xls]CDMA PRA
Data'!$L$3:$L$30=CDMA!$A14,IF('[CDMA_Status.xls]CDMA PRA
Data'!$A$3:$A$30="NA",'[CDMA_Status.xls]CDMA PRA Data'!$M$3:$M$30,""),""))
I moved the CDMA_Status.xls to \\server\folder\CDMA_Status.xls
When I add the path to the new workbook, I get a reference error as if it
can't find it.
Can anyone tell me if this is possible and what the correct way to do it
would be?
Thank you in adnance!!
R.D. Redden
|