I 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 |
__._,_.___
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 (1) |
----------------------------------
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