Add contents of two cells when a tick box is ticked

A

Andy

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
 
I

igorek

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

Ashish Mathur

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top