Change IF function to macro

[gavster]

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.

[davesexcel]

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.

Hi Gavin,
Does your function work for you as it is written?
Could you attach a sample workbook with the working function?

[gavster]

Dave,

Yes the functions works as it currently is.

I've already got a macro running on that page doing several fubnctions, and would like to ideally add this in as a sub-routine.

Thanks,
Gavin.

[davesexcel]

This bit of code will add the formula to the next column when you have made as change in Column F

Please Login or Register  to view this content.

[gavster]

Thanks Dave.

It works blindingly well.