Ayaz,
From: ayaz khan ayazthegreat2001@yahoo.com [ExcelVBA] <ExcelVBA@yahoogroups.com>
To: ExcelVBA <ExcelVBA@yahoogroups.com>
Sent: Tue, Dec 9, 2014 6:59 pm
Subject: Re: [ExcelVBA] Fwd: Excel Question
Dear David In the continuation of below email, i am enclosing a workbook with code solution which has been provided by someone you are requested to please see enclosed workbook code and result , can please make these code concise i hope that you will provide more better solution code by understanding that what result i want On Tuesday, December 9, 2014 3:17 PM, "David Grugeon yahoo@grugeon.com.au [ExcelVBA]" <ExcelVBA@yahoogroups.com> wrote: More info from Ayaz Regards David Grugeon ---------- Forwarded message ---------- From: ayaz khan <ayazthegreat2001@yahoo.com> Date: 9 December 2014 at 20:01 Subject: Re: Excel Question To: "david@grugeon.com.au" <david@grugeon.com.au> Thank you very much David for kind response and support I am again trying my level best to explain about my problem, kindly go through below points 1- I have sheet name fruit database where I have three fields Fruit Name , Fruit Code and Available Fruit Quantity. 2- I have Second Sheet name Fruit Order List in which I record received order detail : Order Date, Fruit Type, DI # if it is otherwise record "-" and in fourth d col i leave fruit code blank and in fifth col e i record required fruit quantity. *What** I want * As i mentioned above that in 2nd sheet i leave fruit code blank, here i want a macro which sees if DI# is blank , 0 or - in sheet2 then macro match sheet1 fruit type with sheet2 and available quantity with required quantity if it equal or greater than copy fruit code from sheet1 to sheet2 in fruit code col like a below table example. *Fruit Data Base Table* [image: Inline image] *Fruit Order received detail* [image: Inline image] *kindly look both data If u look red font of fruit code which will be copied through macro based on above mentioned condition,* On Tuesday, December 9, 2014 12:32 AM, David Grugeon <grugeon@gmail.com> wrote: Dear Ayaz Thank you for that. I have posted the file to the group. I think that you may still not get your problem solved because you have not provided an explanation. The explanation needs to be about the problem, not about the excel spreadsheet. That is you need to explain what your business is doing, what the spreadsheet is trying to achieve and all the constraints for that. The explanation should be in words in an email posted to the group, rather than a few words in a spreadsheet. Have you read the guidance on asking questions at the link David supplied? If you want us to help you you really have to provide us with all the information to enable us to understand the problem. You have not yet done this. Someone did provide you wiyh some code and you response was that it did not fulfill your requirements but you did not say what it did wrong so that helpful person was not able to provide more help. I repeat - Please provide a full explanation of what you are trying to achieve with these spreadsheets. Regards David Grugeon On 9 December 2014 at 01:36, ayaz khan <ayazthegreat2001@yahoo.com> wrote: Dear David Please find another example workbook for your further understaning On Monday, December 8, 2014 12:44 AM, ayaz khan < ayazthegreat2001@yahoo.com> wrote: please find enclosed workbook as advised by you [Non-text portions of this message have been removed]
Posted by: Green <1z@compuserve.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
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