Hello,
I have two sheets in excel that I want to join them by name.
is there any command that can I use like the join command in SQL ?
The first sheet contains the following data:
Name, Telephone, ID
The Second Sheet contain:
Name, Shift, Team.
each name appear only one time in each sheet or it may not appear in
the second sheet.

in SQL, the syntax is:
Select Name, Telephone, Shift
From Sheet1, Sheet2
Where Sheet1.name = Sheet2.name

How do I do that in visual Basic in Excel ?
Thanks.