Minggu, 07 Desember 2014

Re: [ExcelVBA] Re: Help required for a difficult macro


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
Sent from Yahoo Mail on Android

From:"ayaz khan" <ayazthegreat2001@yahoo.com>
Date:Mon, 8 Dec, 2014 at 1:28 AM
Subject:Re: [ExcelVBA] Re: Help required for a difficult macro

Thanks David for your advice I explain my logic in my sent file as well you can see it if you have any confusion or query regarding to my sent file in required result in result sheet please do mention it and I must explain it clearly

Sent from Yahoo Mail on Android

From:"'david braithwaite' dbraithwaite@charter.net [ExcelVBA]" <ExcelVBA@yahoogroups.com>
Date:Mon, 8 Dec, 2014 at 1:14 AM
Subject:[ExcelVBA] Re: Help required for a difficult macro



Suggest that you write the logic required as if you were giving directions to another person who was going to do the process by hand.

Excel is just a tool for implementing such a process, but so is a pencil and paper.  Write for the latter and get surprised by the elegant solution for the former.

Tim Lewis’s posting MAY be such a solution.





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:

More free tutorials and resources available at:




Tidak ada komentar:

Posting Komentar