cav~firez22
Well-known Member
- Joined
- Jun 21, 2006
- Messages
- 543
how would i link to a cell in another workbook?? i cant get this to work
=INDIRECT("'[Collections KPI.xls]"&L1&"'!$E$10")+INDIRECT("'[Collections KPI.xls]"&L1&"'!$H$10")
This is the formula im useing. it will work fine "if" i have collections KPI.xls open.
I would like to beable to show the value, without haveing the Collections kpi open.
Is is possible?
The location of the KPI file is
=INDIRECT("'[Collections KPI.xls]"&L1&"'!$E$10")+INDIRECT("'[Collections KPI.xls]"&L1&"'!$H$10")
This is the formula im useing. it will work fine "if" i have collections KPI.xls open.
I would like to beable to show the value, without haveing the Collections kpi open.
Is is possible?
The location of the KPI file is
O:\Shared Services\Continuous Improvement\Manual Data\KPI's\Collections KPI.xls