I have two worksheets and I want to update a column of a worksheet from the data from another worksheet. The new column will be updated with data matched by an employee number in each worksheet.

Is there some update/ insert function in excel. insert/update into worksheetA.customfield from worksheetb where worksheetA.employeeid = worksheetB.employeeid

something of that sort....anyhelp would be appreciated