excelnoob15
New Member
- Joined
- Aug 27, 2010
- Messages
- 4
Hi everyone, im new to xl. im trying to make a stocktake and ordering system. I've made 2 columns for stock in and stock out, that add/subtract from the total shelf stock of each item. My first problem was when adding or taking stock, the value would be + or - again every time another cell was changed. So i made a very basic macro that clears the column. I currently have the macros linked to a buttons which have to be pressed after each individual value is entered. What i want to do is make the macro auto run after every time a value is added to a cell in that column.
The in and out columns are M:M and N:N respectively
any help would be great, thanks.

The in and out columns are M:M and N:N respectively
any help would be great, thanks.
