Filling formula for a wide range of cells.

[VKu]

Hi,

I need to put in functions/formula in a range of cells from C4:AEM121
With my reference cell being A4:A121 and another reference cell being C2:AEM2

for the first cell C4 the formula would be
=TR(C2,"TR.CompanyMarketCap","SDate=#1",,A4)

for the second cell C5 the formula would be
=TR(C2,"TR.CompanyMarketCap","SDate=#1",,A5)

for the first cell D4 the formula would be
=TR(D2,"TR.CompanyMarketCap","SDate=#1",,A4)

and so on. Please see attached file

I could fix the reference cell C2 by using $C$2, but I would have to do this for all the columns until the last column AME which is quite tedious.
Thus I'd like to know if there are any way to fill in the functions more easily and less time consuming, or perhaps a VBA macro could be used?


Thank you for suggestions and help.

Vku