View Single Post
 
Old 05-16-2017, 07:30 PM
YW3 YW3 is offline Windows 8 Office 2003
Novice
 
Join Date: Jan 2017
Posts: 10
YW3 is on a distinguished road
Default Auto populate cell based on certain situations

A1 is a drop down box containing either 'Yes' or 'No'.

In A2,
If A1 is yes, the user would manually key in a number. This number is a variable.
However, if A1 is no, I'd like A2 to auto-populate '0'.

Do note that A1 and A2 are merged cells.

Is this possible? How can I do this? If not possible, anyone have a suggestion for something similar?
Reply With Quote