Converting formula to a code

Marcol,

I am using Microsoft Office Excel 2003. I do not have any advanced version. I have updated the same in my profile.

I want this macro to function in Excel 2003. Can you kindly help.

Hi Marcol,

Any luck on this? Can we write the coding in Module2 and sheet2 tabs and can we use the change and worksheet activate events to fire the code.
As i did in my attached excel...Is that can be done???