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 copy the B1 formula to all rows in Column B 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 copy the B1 formula to all rows in Column B 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!!