Excel VBA / SQL Union
- by Edge
Hi,
I am trying to Join 2 seperate columns from 2 different sheets to make a longer column from which i can then use a Vlookup from.
Sheet1
A, B, C, D, E, F, G
Sheet2
A, B, C, D, E, F, G
I want to Join(Union) Columns B from sheet1 and C from sheet2 together and find the Distinct values of the new list. I have been working on this for weeks.
Thanks