Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro For Stock Control
Does anyone have a macro for simple stock control?
Here is how I envisage it working The worksheet would have 2 columns - column 1 with a stock code, column 2 with a quantity. The quantity in column 2 needs to be updated when stock is added or taken away. I think 2 macros would be required, 1 to add to stock and 1 to remove from stock. The stock code and quantity to be added or removed would be entered in specific cells at the top of the worksheet. The relevant macro (adding or removing stock) would be run, the macro would search for the stock code in column 1 and adjust the quantity in column 2. Doe this sound possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
stock control help | Excel Discussion (Misc queries) | |||
stock control | Excel Discussion (Misc queries) | |||
Macro For Stock Control | Excel Programming | |||
Stock control formulas, counting and reporting remaining stock | Excel Programming | |||
stock control | Excel Programming |