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
Bookmarks