Further I explain it here again There are 2 sheets one is sheet1 and another is result sheet Sheet1 is a product database Result sheet is a query or order sheet of product By matching ID from result sheet to sheet1, You have to distribute EDI # from sheet1 to result sheet in col c on following conditions 1- where col b is blank or - or 0 value in result sheet 2 _ if above condition is met then distribute order (EDI # from sheet1 col b as to result sheet) as I mentioned in my test file in result sheet and check qty in sheet1 if order product qty less or equal In less qty it goes to next matching ID qty if it is equal or greater then copy this EDI # from sheet1 col b to result sheet in col c I have given example in my sent file in result sheet please go through it carefully 3 - if first matching qty v b p
|
Posted by: ayaz khan <ayazthegreat2001@yahoo.com>
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (17) |
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar