I'm runnig a spreadsheet and I'd like to move from using an IF function (with other nested functions) to a macro.

The current function is:

=IF(F188="","",LOOKUP(ROUNDUP((F188/(LOOKUP(D188,'Calc Sheet'!F:F,'Calc Sheet'!H:H))),0),'Calc Sheet'!K:K,'Calc Sheet'!J:J))

I'd like to have this as a macro so that as data is put into column F, the macro completes the function auomatically.

Thanks for any advice.

Gavin.