mattdeligero
New Member
- Joined
- Sep 15, 2014
- Messages
- 1
Hi,
I have 4 columns and i need a macro where column A be compared to C, and column B to D. When value A matches with any value in column C, and value B with any value in column D, I need value A and value B to be listed on columns E and F in the same order.
<tbody>
</tbody>
I hope i was able to describe it clearly. If you have clarifications, please let me know.
Thank you for your help.
- Matt
I have 4 columns and i need a macro where column A be compared to C, and column B to D. When value A matches with any value in column C, and value B with any value in column D, I need value A and value B to be listed on columns E and F in the same order.
| A1: Dog | B1: Puppy | C1: Bear | D1: Cub | E1: Dog | F1: Puppy |
| A2: Duck | B2: Duckling | C2: Dog | D2: Puppy | E2: Cat | F2: Kitten |
| A3: Cat | B3: Kitten | C3: Kangaroo | D3: Joey | E3 | F3 |
| A4: | B4: | C4: Chicken | D4: Chick | E4 | F4 |
| A5: | B5: | C5: Cat | D5: Kitten | E5 | F5 |
<tbody>
</tbody>
I hope i was able to describe it clearly. If you have clarifications, please let me know.
Thank you for your help.
- Matt
