Hi, It would be big help if anyone can help me with this problem
Suppose in Cell A1:A30 (say) contains some date and with Cell A1: 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....B30 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
SOMEONE has given me the solution via macro:
For i = 1 To Range("A1")
Range("B1").Offset(i-1, 0).Formula = "='c:My Document[Valuation " & Format(Range("A1").Offset(i-1, 0), "dd-mmm-yy") & "]Ingenium'!$E$4"
Next i
This solution works, but the loop seems endless,,, is there any way to stop the loop when reaching cell A30???
Thanks for you reply!
Suppose in Cell A1:A30 (say) contains some date and with Cell A1: 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....B30 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
SOMEONE has given me the solution via macro:
For i = 1 To Range("A1")
Range("B1").Offset(i-1, 0).Formula = "='c:My Document[Valuation " & Format(Range("A1").Offset(i-1, 0), "dd-mmm-yy") & "]Ingenium'!$E$4"
Next i
This solution works, but the loop seems endless,,, is there any way to stop the loop when reaching cell A30???
Thanks for you reply!