PDA

View Full Version : To get a output from table based on condition



mohanraj.610
12-13-2015, 02:22 AM
Hello Friends!! I get more than 1000 inputs on a day. Out of which I can process only a few on day. Say I get 100 bats order, 50 ball, 30 gloves.

But on a day I can deliver only total of 100 including 60 bat 20 bat 20 gloves. I will get input in a excel like attached. I need to run a macro which will give me possible output based on Quantity and Date. Is it possible to automate in any way.

Kindly help!

Aussiebear
12-13-2015, 02:58 PM
Do you have a current Stock number that you could add to the sheet