I need to update a cell in a excel workbook …..The workbook is made up of two worksheets…Worksheet 1 and worksheet 2. Worksheet 1 is the master worksheet that has all the columns and rows I use. Worksheet 2 has two cells – ID and Code. I want to update the codes on worksheet 1 with the codes from worksheet 2 using the id from both sheets has a one to one relationship. Is there a way to create an update query in excel? Can I use vba?