How to change a formula into a VBA code

[Zimmerman]

Could someone help me transform this formula into a VBA code? I am not very good at coding any formulas so any help would be appreciated.

This formula is in cell L14 and i will need to duplicate it accross cells in the range of L8: Q44, but i'm figuring i might be able to copy and paste after i get it in a VBA format and just change my values.

=IF(ISNA(INDEX('Weekly Total'!$B$8:$H$2000,MATCH(1,('Weekly Total'!$D$8:$D$2000=$D$14)*('Weekly Total'!$B$8:$B$2000=L7),0),7)),"",INDEX('Weekly Total'!$B$8:$H$2000,MATCH(1,('Weekly Total'!$D$8:$D$2000=$D$14)*('Weekly Total'!$B$8:$B$2000=L7),0),7))

[pike]

Hi Zimmerman,
Your can record this in a macro
Just start recorder
select the cell will formula
go to the formula bar and click enter
Its all captured in the recorder