Hi,
I need a help from the other which is similar to my issue. I have provided the link below.
I have 2 sheets (sheet1putaway & sheet 2 -issued)
when the second sheet is entered, the reduction should start from the minimum stock from the 1st sheet (30), once it becomes zero the reduction should go to the minimum stock.(40) & zero stocks to be removed from the 1st sheet.
Thanks in advance. I have attached my sample workbook herewith.
http://www.excelforum.com/excel-prog...-of-state.html
ravi
Bookmarks