shadow12345
Well-known Member
- Joined
- May 10, 2004
- Messages
- 1,238
I have the below formula in a sheet, all it does is copies values into a summary sheet. There are around 40 of these linking to different points for each day. The file rubber position is saved daily in the format i:\rubber position dd.mm.yy.xls
='I:\[RUBBER POSITION 16.06.08.xls]RUBBER POSITION'!$BP$205
which works fine, however what i want to do is to rewrite this formula to do the below
=='I:\[RUBBER POSITION (the value in cell b3 the date im trying to target in the formula) xls]RUBBER POSITION'!$BP$205
='I:\[RUBBER POSITION 16.06.08.xls]RUBBER POSITION'!$BP$205
which works fine, however what i want to do is to rewrite this formula to do the below
=='I:\[RUBBER POSITION (the value in cell b3 the date im trying to target in the formula) xls]RUBBER POSITION'!$BP$205