Selasa, 09 Desember 2014

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]

#yiv2917083734 #yiv2917083734 -- #yiv2917083734ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2917083734 #yiv2917083734ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2917083734 #yiv2917083734ygrp-mkp #yiv2917083734hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2917083734 #yiv2917083734ygrp-mkp #yiv2917083734ads {margin-bottom:10px;}#yiv2917083734 #yiv2917083734ygrp-mkp .yiv2917083734ad {padding:0 0;}#yiv2917083734 #yiv2917083734ygrp-mkp .yiv2917083734ad p {margin:0;}#yiv2917083734 #yiv2917083734ygrp-mkp .yiv2917083734ad a {color:#0000ff;text-decoration:none;}#yiv2917083734 #yiv2917083734ygrp-sponsor #yiv2917083734ygrp-lc {font-family:Arial;}#yiv2917083734 #yiv2917083734ygrp-sponsor #yiv2917083734ygrp-lc #yiv2917083734hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2917083734 #yiv2917083734ygrp-sponsor #yiv2917083734ygrp-lc .yiv2917083734ad {margin-bottom:10px;padding:0 0;}#yiv2917083734 #yiv2917083734actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2917083734 #yiv2917083734activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2917083734 #yiv2917083734activity span {font-weight:700;}#yiv2917083734 #yiv2917083734activity span:first-child {text-transform:uppercase;}#yiv2917083734 #yiv2917083734activity span a {color:#5085b6;text-decoration:none;}#yiv2917083734 #yiv2917083734activity span span {color:#ff7900;}#yiv2917083734 #yiv2917083734activity span .yiv2917083734underline {text-decoration:underline;}#yiv2917083734 .yiv2917083734attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2917083734 .yiv2917083734attach div a {text-decoration:none;}#yiv2917083734 .yiv2917083734attach img {border:none;padding-right:5px;}#yiv2917083734 .yiv2917083734attach label {display:block;margin-bottom:5px;}#yiv2917083734 .yiv2917083734attach label a {text-decoration:none;}#yiv2917083734 blockquote {margin:0 0 0 4px;}#yiv2917083734 .yiv2917083734bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2917083734 .yiv2917083734bold a {text-decoration:none;}#yiv2917083734 dd.yiv2917083734last p a {font-family:Verdana;font-weight:700;}#yiv2917083734 dd.yiv2917083734last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2917083734 dd.yiv2917083734last p span.yiv2917083734yshortcuts {margin-right:0;}#yiv2917083734 div.yiv2917083734attach-table div div a {text-decoration:none;}#yiv2917083734 div.yiv2917083734attach-table {width:400px;}#yiv2917083734 div.yiv2917083734file-title a, #yiv2917083734 div.yiv2917083734file-title a:active, #yiv2917083734 div.yiv2917083734file-title a:hover, #yiv2917083734 div.yiv2917083734file-title a:visited {text-decoration:none;}#yiv2917083734 div.yiv2917083734photo-title a, #yiv2917083734 div.yiv2917083734photo-title a:active, #yiv2917083734 div.yiv2917083734photo-title a:hover, #yiv2917083734 div.yiv2917083734photo-title a:visited {text-decoration:none;}#yiv2917083734 div#yiv2917083734ygrp-mlmsg #yiv2917083734ygrp-msg p a span.yiv2917083734yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2917083734 .yiv2917083734green {color:#628c2a;}#yiv2917083734 .yiv2917083734MsoNormal {margin:0 0 0 0;}#yiv2917083734 o {font-size:0;}#yiv2917083734 #yiv2917083734photos div {float:left;width:72px;}#yiv2917083734 #yiv2917083734photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv2917083734 #yiv2917083734photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2917083734 #yiv2917083734reco-category {font-size:77%;}#yiv2917083734 #yiv2917083734reco-desc {font-size:77%;}#yiv2917083734 .yiv2917083734replbq {margin:4px;}#yiv2917083734 #yiv2917083734ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2917083734 #yiv2917083734ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2917083734 #yiv2917083734ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2917083734 #yiv2917083734ygrp-mlmsg select, #yiv2917083734 input, #yiv2917083734 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2917083734 #yiv2917083734ygrp-mlmsg pre, #yiv2917083734 code {font:115% monospace;}#yiv2917083734 #yiv2917083734ygrp-mlmsg * {line-height:1.22em;}#yiv2917083734 #yiv2917083734ygrp-mlmsg #yiv2917083734logo {padding-bottom:10px;}#yiv2917083734 #yiv2917083734ygrp-msg p a {font-family:Verdana;}#yiv2917083734 #yiv2917083734ygrp-msg p#yiv2917083734attach-count span {color:#1E66AE;font-weight:700;}#yiv2917083734 #yiv2917083734ygrp-reco #yiv2917083734reco-head {color:#ff7900;font-weight:700;}#yiv2917083734 #yiv2917083734ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2917083734 #yiv2917083734ygrp-sponsor #yiv2917083734ov li a {font-size:130%;text-decoration:none;}#yiv2917083734 #yiv2917083734ygrp-sponsor #yiv2917083734ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2917083734 #yiv2917083734ygrp-sponsor #yiv2917083734ov ul {margin:0;padding:0 0 0 8px;}#yiv2917083734 #yiv2917083734ygrp-text {font-family:Georgia;}#yiv2917083734 #yiv2917083734ygrp-text p {margin:0 0 1em 0;}#yiv2917083734 #yiv2917083734ygrp-text tt {font-size:120%;}#yiv2917083734 #yiv2917083734ygrp-vital ul li:last-child {border-right:none !important;}#yiv2917083734

[Non-text portions of this message have been removed]

__._,_.___

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 (2)
----------------------------------
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:

Poskan Komentar