I have two worksheets in same Excel file. Worksheet 1 has a record ID number
in column A and data in other columns. I have a column (lets say K) in
worksheet 1 that I want to update (replace) from worksheet 2.

Worksheet 2 doesn't have as many records as worksheet 1. Worksheet 2 also
has an record ID in column A. All IDs in WorkSheet 2 match an ID in
worksheet 1. I want to take an ID from worksheet 2, find its corresponding
ID in worksheet 1 and for that row in worksheet 1 update column K from column
B in worksheet 2 where the Worksheet 2 ID = Worksheet 1 ID.

I prefer to use an Excel functions to do it, but if I have to I would use
SQL if it is possible. Any help will be appreciated.

JR