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).
02-25-2013, 05:43 PM
Similar Threads
Keep cell in formula constant
Windows 7 64bit 
Office 2010 32bit
Hybrid Mode