Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-16-2017, 07:30 PM
YW3 YW3 is offline Auto populate cell based on certain situations Windows 8 Auto populate cell based on certain situations Office 2003
Novice
Auto populate cell based on certain situations
 
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
 

Tags
autopopulate



Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto populate cell based on certain situations Excel to auto populate dates based on start and end patidallas22 Excel Programming 9 04-21-2014 03:14 PM
Auto populate cell based on certain situations trying to use vlookup to calculate several different situations in one cell heastlund Excel 3 11-21-2013 12:38 PM
Auto populate cell based on certain situations auto cell populate 2 Stevejd58 Excel 3 08-20-2013 04:23 PM
Auto populate cell based on certain situations 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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:46 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft