Excel VBA, once a cell value is changed, change other cell in same row with specific text

[Patty3-4]

Good afternoon,

I would like to create a VBA worksheet command that changes column 10 to "New ID Assigned" once column 9 in the same row is changed. This should continue to the next row and the next and the next..... There is currently a vlookup code in column 9 of each row which will be overwritten once the information is received and typed in, so it's not empty per say. I would prefer to not have to run a macro for each row, if possible. Any help would be appreciated.

 

[Patty3-4]

Good afternoon,

I would like to create a VBA worksheet command that changes column 10 to "New ID Assigned" once column 9 in the same row is changed. This should continue to the next row and the next and the next..... There is currently a vlookup code in column 9 of each row which will be overwritten once the information is received and typed in, so it's not empty per say. I would prefer to not have to run a macro for each row, if possible. Any help would be appreciated.

Excel version 2301