decent_boy
Board Regular
- Joined
- Dec 5, 2014
- Messages
- 130
- Office Version
- 2016
- Platform
- Windows
Hello, hope that you are well
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.
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
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 |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
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 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>