| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allowing only 1 check box to be ticked | Excel Discussion (Misc queries) | |||
| get a list of ticked add-in | Excel Worksheet Functions | |||
| compare the contents of one range of cells with the contents of a. | Excel Discussion (Misc queries) | |||
| ticked items on Pivot tables | Excel Discussion (Misc queries) | |||
| Check/Tick box's and Mandatory cells | Excel Discussion (Misc queries) | |||
Linear Mode
