Incorporating IF MAX formula into a macro

[batjl9]

Hi All

I have set up a formula within a table which searches race results I manually enter on another excel workbook and automatically updates a horses total wins, so that if a horse wins a race, this will be shown on the table. The current formula works, however as I am tracking many horses wins it is making the processing of excel very slow. Is there a way of making this into a macro so as to not slow down the computer?I have attached a file to show what the table will look like. Below is the formula:

 =IF(MAX(IF(('C:\Users\McKinleys\Dropbox\[Season 36.xlsm]G1 Graded'!$D:$D=$B2), 'C:\Users\McKinleys\Dropbox\[Season 36.xlsm]G1 Graded'!$K:$K))=0,$D2,MAX(IF(('C:\Users\McKinleys\Dropbox\[Season 36.xlsm]G1 Graded'!$D:$D=$B2), 'C:\Users\McKinleys\Dropbox\[Season 36.xlsm]G1 Graded'!$K:$K)))

Thanks in advance
Gemma