Hi there,
I'm trying to combine 2 tables into 1.
The first table contains data about deliveries and the second contains data about serials.
I want to get a new table containing data from both tables, while joining the 2 tables by a column which both tables share called "orderCertificate".
* The Deliveries table contains many deliveries while each delivery has a unique orderCertificate, which can be attached to many records from the Serials.
An Example representing the 2 tables:
Deliveries:
Delivery1 | info about delivery1 | orderCertificate1
Delivery2 | info about delivery2 | orderCertificate2
Serials:
Item1 | info about item 1 | item1Serial | orderCertificate1
item2 | info about item 2 | item2Serial | orderCertificate1
item3 | info about item 3 | item3Serial | orderCertificate2
Is there any VBA function or a simple way to do that in excel?
I come from the SQL world and very rarely touched excel so if you could help me while explaining what I should change in order for things to work I will highly appreciate it!
Thanks in advance
{ If anyone has a solution for the problem in access it will also be great }
I'm trying to combine 2 tables into 1.
The first table contains data about deliveries and the second contains data about serials.
I want to get a new table containing data from both tables, while joining the 2 tables by a column which both tables share called "orderCertificate".
* The Deliveries table contains many deliveries while each delivery has a unique orderCertificate, which can be attached to many records from the Serials.
An Example representing the 2 tables:
Deliveries:
Delivery1 | info about delivery1 | orderCertificate1
Delivery2 | info about delivery2 | orderCertificate2
Serials:
Item1 | info about item 1 | item1Serial | orderCertificate1
item2 | info about item 2 | item2Serial | orderCertificate1
item3 | info about item 3 | item3Serial | orderCertificate2
Is there any VBA function or a simple way to do that in excel?
I come from the SQL world and very rarely touched excel so if you could help me while explaining what I should change in order for things to work I will highly appreciate it!
Thanks in advance
{ If anyone has a solution for the problem in access it will also be great }