Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 30th 07, 08:42 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 8
Default How to Auto-populate cell based on selection of a list item

Hi,
I'd like to know how to auto-populate the cells of a specific column, based
on the user selecting a particular list item from a list.

E.g. If user selects "No" from "Married?" list box, then "Years Married"
cell is auto-populated with "N/A".

Thanks
Anna


  #2   Report Post  
Old April 30th 07, 08:51 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 10,593
Default How to Auto-populate cell based on selection of a list item

Just put a formula in those cells referring back to the list value

=IF(H1="No","N/A",some_calculation)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"AK9955" wrote in message
...
Hi,
I'd like to know how to auto-populate the cells of a specific column,
based
on the user selecting a particular list item from a list.

E.g. If user selects "No" from "Married?" list box, then "Years Married"
cell is auto-populated with "N/A".

Thanks
Anna



  #3   Report Post  
Old April 30th 07, 10:04 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 663
Default How to Auto-populate cell based on selection of a list item

Hi,

Excel -- Data Validation -- Create Dependent Lists.

Use this URL: http://www.contextures.com/xlDataVal02.html

Challa Prabhu


"AK9955" wrote:

Hi,
I'd like to know how to auto-populate the cells of a specific column, based
on the user selecting a particular list item from a list.

E.g. If user selects "No" from "Married?" list box, then "Years Married"
cell is auto-populated with "N/A".

Thanks
Anna



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I Auto Populate a cell with a chart based on a value Bryan[_2_] Excel Worksheet Functions 0 March 24th 07 01:03 AM
auto populate cell based on previous cell drop down list selectio. PuzzledbyLists Excel Discussion (Misc queries) 2 September 11th 06 01:28 AM
Auto populate several cells based on a selection from drop down li Sheldon Excel Discussion (Misc queries) 3 January 13th 06 08:12 PM
need to populate several cells based on drop down menu selection TerriF Excel Discussion (Misc queries) 1 May 18th 05 10:27 PM
limit cell list selection based on the selection of another list lorraine Excel Worksheet Functions 2 December 14th 04 08:17 PM


All times are GMT +1. The time now is 11:48 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017