Consulting

Results 1 to 2 of 2

Thread: To get a output from table based on condition

  1. 12-13-2015, 02:22 AM #1
    mohanraj.610
    mohanraj.610 is offline
    VBAX Regular
    Joined
    Aug 2015
    Posts
    14
    Location

    To get a output from table based on condition

    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!
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  2. 12-13-2015, 02:58 PM #2
    Aussiebear
    Aussiebear is offline
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,059
    Location
    Do you have a current Stock number that you could add to the sheet
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules