Hi, It would be big help if anyone can help me with this problem
Suppose in Cell A1 I have date 25-Mar-02
And in Cell B1 I have fomula:
='c:My Document[Valuation 25-Mar-02.xls]Ingenium'!$E$4
NOTE: The file name has the date within to correspond with Cell A1.
The problem here is suppose I have to fill the B1 formula to B2,B3.... etc in and ensuring the file name within each formula has the date correspond to the date in the same row in Column A
Such as Cell A2: 26-Mar-02
So Cell B2:='c:My Document[Valuation 26-Mar-02.xls]Ingenium'!$E$4
So On...
Please help!!
Suppose in Cell A1 I have date 25-Mar-02
And in Cell B1 I have fomula:
='c:My Document[Valuation 25-Mar-02.xls]Ingenium'!$E$4
NOTE: The file name has the date within to correspond with Cell A1.
The problem here is suppose I have to fill the B1 formula to B2,B3.... etc in and ensuring the file name within each formula has the date correspond to the date in the same row in Column A
Such as Cell A2: 26-Mar-02
So Cell B2:='c:My Document[Valuation 26-Mar-02.xls]Ingenium'!$E$4
So On...
Please help!!