Hello guys,
does anyone have a code that could split one worksheet (or table) into 2 worksheets (or tables) and "connect" them with Primary - Foreign Keys. Like in database tables.
Basicly copy the Contry column into a new sheet, remove duplicates, add a unique number column called CountryID and then create a new worksheet where we don't have Country column but the CountryID

For example, if I have:
OrderID	 OrderDate    Country
10248	04.07.2015	France
10249	05.07.2015	Germany
10250	08.07.2015	Brazil
10251	08.07.2015	France
10252	09.07.2015	Belgium
10253	10.07.2015	Brazil
10254	11.07.2015	Switzerland
10255	12.07.2015	Switzerland
Is there a code to create this 2 worksheets (or tables) like this

Countrys worksheet:
CountryID	Country
1	France
2	Germany
3	Brazil
4	Belgium
5	Switzerland
New Orders sheet with CountryID but without Country:
OrderID	 OrderDate   	CountryID
10248	04.07.2015	1
10249	05.07.2015	2
10250	08.07.2015	3
10251	08.07.2015	1
10252	09.07.2015	4