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.

Please Login or Register  to view this content.

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