Hello,
I am looking for some help with my little challenge.
I am trying to combine data from 2 different sheets in an automated way, but I don't know VBA and macro well enough to get this to work without help.
I have 2 sheets and I want all the combinations from the to sheets to be copied to sheet3:
To make it easier to explain this if give an example of my situation (my actual tables are much bigger, but for explaining it this should be sufficient)
SHEET1
<tbody>
</tbody>
SHEET2
<tbody>
</tbody>
SHEET3 (result)
<tbody>
</tbody>
If there is a simple way to realize this without a macro? if not can somebody help me out with a macro for this?
Any help is very much appreciated.
Thanks,
Martin
I am looking for some help with my little challenge.
I am trying to combine data from 2 different sheets in an automated way, but I don't know VBA and macro well enough to get this to work without help.
I have 2 sheets and I want all the combinations from the to sheets to be copied to sheet3:
To make it easier to explain this if give an example of my situation (my actual tables are much bigger, but for explaining it this should be sufficient)
SHEET1
item | price | start | end |
ABC | 10 | 1-1-17 | 31-12-17 |
DEF | 15 | 1-1-17 | 1-1-18 |
GHI | 20 | 1-3-17 | 3-3-18 |
<tbody>
</tbody>
SHEET2
contact | country | number |
NameA | NL | 12345678 |
NameB | BE | 87654321 |
NameC | FR | 45678123 |
<tbody>
</tbody>
SHEET3 (result)
item | price | start | end | contact | country | number |
ABC | 10 | 1-1-17 | 31-12-17 | NameA | NL | 12345678 |
DEF | 15 | 1-1-17 | 1-1-18 | NameA | NL | 12345678 |
GHI | 20 | 1-3-17 | 3-3-18 | NameA | NL | 12345678 |
ABC | 10 | 1-1-17 | 31-12-17 | NameB | BE | 87654321 |
DEF | 15 | 1-1-17 | 1-1-18 | NameB | BE | 87654321 |
GHI | 20 | 1-3-17 | 3-3-18 | NameB | BE | 87654321 |
ABC | 10 | 1-1-17 | 31-12-17 | NameC | FR | 45678123 |
DEF | 15 | 1-1-17 | 1-1-18 | NameC | FR | 45678123 |
GHI | 20 | 1-3-17 | 3-3-18 | NameC | FR | 45678123 |
<tbody>
</tbody>
If there is a simple way to realize this without a macro? if not can somebody help me out with a macro for this?
Any help is very much appreciated.
Thanks,
Martin