Howdy all!

I need to convert this formula to a VBA code
{=MAX(IF(RAW!A:A=Consolidate!A2,RAW!T:T,0))}

My RAW ranges are up to 45,000 records, and the Consolidate sheet is up to 35,000 records, so running that as a formula is quite a slog.

I'm just getting into VBA programming, and don't quite know how to handle this.

Any assistance is much appreciated!