I have 2 excel sheets. Both have the Emp id's identical but can be in a scattered manner and in Colum A in each sheet.
What i want to do is Excel B should search for the emp id in Excel A and copy all the contents next to it
In excel A i have
Emp id,Age,Name and in excel B i have seat no and county.
I want to combine them to one sheet.