Add contents of two cells when a tick box is ticked

  • Thread starter Thread starter Andy
  • Start date Start date
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
 
it has to be done in the macro. The code has to read the check off and adjust
the formula in the cell
 
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

use month in cell date to sum all relevant cells 2
Add/Subtract columns from tab to tab in same file 3
Round Down by a specific number 0
Inventory Tracking Sheet 2
multiple subtraction from one field 1
Changing the apperance of values 2
Access Stock In Hand query in access 2007 0
Retrieve values from 2 worksheets. 3

Back
Top