Hello Guys,
I got the following sheet and formula in there:
But, the formula in O3 won't work without opening the other file. Is there any way I can make the formula get the result without opening the file?
And is there a better and shorter formula to do the same job?
Asad
I got the following sheet and formula in there:
Excel Workbook | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |||
1 | RDO As On | RDO As On | ||||||||||||||||
2 | 30/03/2011 | 15/05/2011 | 13/03/2011 | 20/03/2011 | 27/03/2011 | 3/04/2011 | 10/04/2011 | 17/04/2011 | 24/04/2011 | 1/05/2011 | 8/05/2011 | 15/05/2011 | ||||||
3 | DF064 | ADDERLY | ADDERLY, David Allan | 40:00:00 | 54:00:00 | 0 | ||||||||||||
4 | DF002 | ADDICOTT | ADDICOTT, Steven Charles | 20:00:00 | 34:00:00 | 0 | ||||||||||||
5 | DF078 | AGGETT | AGGETT, Brian Charles | 30:00:00 | 44:00:00 | 4 | ||||||||||||
6 | DF129 | AKHTAR | AKHTAR, Tahir Mamhood | 15:00:00 | 29:00:00 | 0 | ||||||||||||
RDO |
But, the formula in O3 won't work without opening the other file. Is there any way I can make the formula get the result without opening the file?
And is there a better and shorter formula to do the same job?
Asad