Dave thanks for your reply , but let me explain you more about this data, actually sheet1 is source data which is distributing/copying data in result sheet as per given Qty of result sheet in col D like as you mentioned that ("(1) A1545 has quantity 10 in Sheet 1, but only 1 in the result sheet.") this is because in result sheet the Qty in D col requirement is 1 and this is logic i want to communicate.
(2) B6789 has one entry in Sheet 1) sorry it is wrong entry.
Sir, i can explain you more in case of any confusion.
| Sheet1 | ||
| ID | EDI # | Qty |
| A11 | A1245 | 2 |
| A11 | A1345 | 1 |
| A11 | A1545 | 10 |
| A16 | B4567 | 3 |
| A16 | B6789 | 30 |
| Result Sheet | |||
| ID | DI# | EDI # | Qty |
| A11 | - | A1245 | 2 |
| A11 | - | A1345 | 1 |
| A11 | - | A1545 | 1 |
| A12 | 2345 | 1 | |
| A13 | 3245 | 1 | |
| A16 | - | B4567 | 3 |
| A16 | - | B6789 | 2 |
On Saturday, December 6, 2014 4:05 AM, "'David Smart' smartware.consulting@gmail.com [ExcelVBA]" <ExcelVBA@yahoogroups.com> wrote:
Sorry, I can't see how you go from your Sheet1 to your result sheet.
(1) A1545 has quantity 10 in Sheet 1, but only 1 in the result sheet.
(2) B6789 has one entry in Sheet 1, but two entries in the result sheet. Also, however, the quantity 30 has become quantity 2 and quantity 1 - what about the other 27?
Please explain how Sheet 1 transforms into the entries in the result sheet, with particular emphasis on the ones that don't have the same quantity, and on the ones that have more than one entry in the result sheet.
Regards, Dave S
----- Original Message -----Sent: Saturday, December 06, 2014 6:44 AMSubject: [ExcelVBA] Help required for a difficult macroI need a macro for my result sheet , let me explain you that i have sheet1 and there are 3 fields from col a to c and i need a macro for result sheet which matches ID number from result sheet col a (where DI# is blank in col b) with sheet1 col a and copy/distribute b col value from sheet1 to result sheet in col c which must be equal d col value , ok please see below example in red highlighted font cells as a macro result.
Sheet1 ID EDI # Qty A11 A1245 2 A11 A1345 1 A11 A1545 10 A16 B4567 3 A16 B6789 30
Result Sheet ID DI# EDI # Qty A11 - A1245 2 A11 - A1345 1 A11 - A1545 1 A12 2345 1 A13 3245 1 A16 - B4567 3 A16 - B6789 2 A16 - B6789 1 No virus found in this message.
Checked by AVG - www.avg.com
Version: 2015.0.5577 / Virus Database: 4235/8682 - Release Date: 12/04/14
__._,_.___
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 (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
----------------------------------
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