I am looking at creating a macro/VBA to automate updating data in Excel. Here is the scenario:

Asset reassignment
- A list of return assets by different models
- A list of engineers that need different asset of model
- The macro to assign engineer with the next available asset