automatically change the value in one cell based on other

[sudhansu121]

Hi All,

Hope you all are safe and doing well.

I need a help with the excel with the below

I need 2 things;
1st:
I have a sheet with data validation controls. Please see the attached excel sample sheet.
What I need is when a value is selected from the dropdown list in Column B, in column A it should come as "Ready for Review".
I have tried a formula (check A7), but not helping me .

2nd:
When user select the dropdown list in column B and the status gets updated to "Ready for review" in column A, I need an audit trial in column C, Like the date, time and user name. I am not sure is this is possible.

Thanks in advance.
EDIT1: added xlsm sheet for Sintek to review.

NOTE: The code works fine. I was trying to run the code so was having problem. you do not have do anything. you just put it in Sheet1 and save it. I will work seamlessly.