Need to create a pop up data entry box - with conditions

[MJ72]

So...I currently have a spreadsheet that acts like a call log (Sheet1)(Call Log). In one of the cells I have a drop down menu that allows for a "yes" or "no" answer. I'd like to create a code that when the answer is "yes" a pop box appears with another drop down menu with 3 choices (let's say A, B, or C) and then have the selected answer auto populate into the next available cell in a specific column of a table (cells M3:M12)on another sheet of the workbook (Sheet 5)(P&A). Is this possible and if so, how? Thanks.

 

[FrankViewPoint]

Can I suggest that you look at the entry under the heading "Multiple drop down lists in the same cell" from wolfschenck1954, in the thread that started on Oct 9, 2021. I think that the approach recommended might give you the functionality you are looking for.