Add contents of two cells when a tick box is ticked
 

I have a stock control sheet with quantity in stock and quantity ordered.
When the order arrives I want to be able to tick a check box, thus adding the
quantity in stock cell to the amount ordered cell to show in the quantity in
stock cell.
Thanks

Add contents of two cells when a tick box is ticked
 

it has to be done in the macro. The code has to read the check off and adjust
the formula in the cell

"Andy" wrote:

I have a stock control sheet with quantity in stock and quantity ordered.
When the order arrives I want to be able to tick a check box, thus adding the
quantity in stock cell to the amount ordered cell to show in the quantity in
stock cell.
Thanks

Add contents of two cells when a tick box is ticked
 

Hi,

I wonder why you need a check box for it. You simply put a formula in the
"Quantity in stock":

=if(countblank(cell_ref)=1,previous quantity ref,previous quantity
ref+cell_ref)

cell_ref is the cell reference of the quantity ordered.



--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Andy" wrote in message
...
I have a stock control sheet with quantity in stock and quantity ordered.
When the order arrives I want to be able to tick a check box, thus adding
the
quantity in stock cell to the amount ordered cell to show in the quantity
in
stock cell.
Thanks