adamsm
02-17-2011, 12:48 PM
Hi anyone,
My workbook has two sheets. One named as "Bill" and the other as “Data”.
For example cell F35 of the active sheet has 0014 cell M35 has 100 and cell O6 has 0001.
In “Data” sheet cell B20 has 0001 and cell C20 has 0014 and F20 has 30.
How could I write a code that would change the value in cell F20 of the sheet "Data" to 200 when the user changes the value of cell M35 in the active sheet to 200.
Any suggestion on this would be appreciated.
My workbook has two sheets. One named as "Bill" and the other as “Data”.
For example cell F35 of the active sheet has 0014 cell M35 has 100 and cell O6 has 0001.
In “Data” sheet cell B20 has 0001 and cell C20 has 0014 and F20 has 30.
How could I write a code that would change the value in cell F20 of the sheet "Data" to 200 when the user changes the value of cell M35 in the active sheet to 200.
Any suggestion on this would be appreciated.