VLookup Data Validation and Macro action

[Kahm111]

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!

[venkat1926]

see attached file and text box within.

[Trebor76]

Hi Kahm111,

Have a look at the attached where the code is attached to the sheet as a worksheet_change event macro whenever cell N2 is changed and there's also an entry in cell N1.

Regards,

Robert