VBA code for copying and combining data from 2 sheets (joining 2 tables into a new one)

[mulmar74]

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

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

 

[Fazza]

Welcome, Martin

this past thread is similar https://www.mrexcel.com/forum/excel...ble-combinations-two-lists-without-macro.html

a query can join the tables, without formulas & without macros

regards, Fazza