I have two fields in an Excel file. The first one is Code and the second one is Location. I would like to update Location with a specific value based on the value in Code. For example, if the value in Code is 123, then I want the value in Location to be ABC. If the value in Code is 456, then I want the value in Location to be XYZ. For all other values in Code, I want no value to populate in Location. How can I write a CASE statement to add this into my existing macro?
Bookmarks