KWFIELDS969
New Member
- Joined
- Mar 24, 2014
- Messages
- 1
I am using excel to manage my spare parts inventory. I would like to copy one column to another on the fist of each month and then reset two columns to zero after the copy event. I have 4 columns that need work, 1. Monthly start qty 2. qty in stock 3. parts received 4. parts used. I need to have the numbers from the QTY in stock column to be copied to the Monthly start qty column on the first of every month. Then I need to reset the two remaining columns to a value of zero after the move is completed.
<tbody>
</tbody>
monthly start | parts received | parts used | qty in stock |
400 | 1 | 2 | 399 |
2 | 2 | 1 | 3 |
<tbody>
</tbody>