VBA code to insert formula with automatic cell referencing & size

Hi,

In the attached spreadsheet, I am trying to insert the following formula starting in cell C2 then to automatically fill to the last cell based on the number of IDs in column A.

=IF(B2="Y",BDP(I3&" ISIN",$C$1, "PX_ASK",D2,"SETTLE_DT",TEXT(D2,"yyyymmdd")),BDP(I3&" ISIN",$C$1, "PX_ASK",E2,"SETTLE_DT",TEXT(E2,"yyyymmdd")))

So I need the VBA code to:
- automatically change for cell references
- automatically fill to the last row of data so if I were to add another row ID, the macro would recognize that and fill accordingly.
Book5.xlsx

Thanks in advance,

Kevin