C
Chacky
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?
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?