Quote:
Originally Posted by niton
The hope is that although the OP has not learnt enough to describe this impractical assignment clearly, the intent is to enter data in the F column followed by entering data in the G column. In the Worksheet.Change code the product of F and G will replace the value in G.
|
Even so, I'd be surprised if the desired result can't be achieved without resorting to Worksheet_Change macros (eg via a series of IF tests or a LOOKUP formula that references a table for the variable values).