compute one of two missing value?

  • Thread starter Thread starter james
  • Start date Start date
J

james

I want to create a table like this:

column A is the name of the person
column B is height in feet
column C is height in meters

How do I set it up so that if I enter a number in the feet column, excel
would calculate and fill in the meter column, and if I fill in the meter
column, excel would calculate and fill in the feet column?
 
use a worksheet_change event
if target.column=2 then target.offset(,1)=target*_____
if target.column=3 then target.offset(,-1)=target/_____
 
Back
Top