|
|
#1
05-16-2017, 07:30 PM
|
|||
|
|||
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? 
|
| Tags |
| autopopulate |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Excel to auto populate dates based on start and end
|
patidallas22 | Excel Programming | 9 | 04-21-2014 03:14 PM |
|
trying to use vlookup to calculate several different situations in one cell
|
heastlund | Excel | 3 | 11-21-2013 12:38 PM |
|
auto cell populate 2
|
Stevejd58 | Excel | 3 | 08-20-2013 04:23 PM |
|
auto cell populate
|
Stevejd58 | Excel | 14 | 05-13-2013 02:22 AM |
| Auto-populate an MS Word table cell with text from a diff cell? | dreamrthts | Word Tables | 0 | 03-20-2009 01:49 PM |
Windows 8 
Office 2003
Threaded Mode