I've been trying to figure out how to create a macro for this function...

I have this table:

In Column A are device numbers ranging from 1000 to 1250.
In Column B is each device's respective status (i.e. damaged, out for repair, etc)

I'm making a menu to side of this table:

N1 Has a drop down of all listed devices

I'd like N2 to have a drop down of all applicable status' and when a status is selected, it would change the status for the device in N1 on the table in Column B.

Thanks for any help!