FROM [Sheet1$] as S1 LEFT OUTER JOIN [Sheet2$] as S2 ON S1.A = S2.A Summary: Excel SQL I prefer using SQL in Excel over writing any VBA macro if possible. The reasons for this are the following: Editable and re