Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 22nd 19, 04:16 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2019
Posts: 3
Default Create a dependent drop down list in Google Sheets in a whole columnnot just one row

Hello everyone,

I really need some help trying to complete this task. After trying and investigating all over I can't manage to figure this out. What I'm trying to achieve is to obtain a list of options in a drop down list based on another list shown in a drop down list.I have successfully done it with the first entry,but it is not possible to drag this set up to the remaining cells below because once you select the 2nd drop down list in the row beneath the first,the populate list corresponds to the the first row populated list.
I've been watching youtube videos about this matter,but no lucking undestanding how to do this.

Thank you for your time.


Please see attached file example

  #2   Report Post  
Old April 22nd 19, 04:17 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2019
Posts: 3
Default Create a dependent drop down list in Google Sheets in a wholecolumn not just one row

On Monday, April 22, 2019 at 10:16:49 AM UTC-5, Joseph wrote:
Hello everyone,

I really need some help trying to complete this task. After trying and investigating all over I can't manage to figure this out. What I'm trying to achieve is to obtain a list of options in a drop down list based on another list shown in a drop down list.I have successfully done it with the first entry,but it is not possible to drag this set up to the remaining cells below because once you select the 2nd drop down list in the row beneath the first,the populate list corresponds to the the first row populated list.
I've been watching youtube videos about this matter,but no lucking undestanding how to do this.

Thank you for your time.


Please see attached file example


file link:

https://docs.google.com/spreadsheets...KIU/edit#gid=0
  #3   Report Post  
Old April 22nd 19, 04:18 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2019
Posts: 3
Default Create a dependent drop down list in Google Sheets in a wholecolumn not just one row

On Monday, April 22, 2019 at 10:16:49 AM UTC-5, Joseph wrote:
Hello everyone,

I really need some help trying to complete this task. After trying and investigating all over I can't manage to figure this out. What I'm trying to achieve is to obtain a list of options in a drop down list based on another list shown in a drop down list.I have successfully done it with the first entry,but it is not possible to drag this set up to the remaining cells below because once you select the 2nd drop down list in the row beneath the first,the populate list corresponds to the the first row populated list.
I've been watching youtube videos about this matter,but no lucking undestanding how to do this.

Thank you for your time.


Please see attached file example

  #4   Report Post  
Old April 23rd 19, 01:02 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 1,055
Default Create a dependent drop down list in Google Sheets in a whole column not just one row

I suggest you review the basics for creating dependant dropdown lists here...

https://www.contextures.com/xlDataVal02.html

...then read the Google Sheets user guide for DataValidation basics. The key is
in how you define the named ranges containing your lists and so between these 2
suggested actions you should be able to *figure it out* so you can share it
with others using Google Sheets.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


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 to: Create Dependent Drop Down in a Form Benjamin Excel Programming 2 August 20th 09 05:49 PM
How to create 2 dependent drop down lists from 1 original drop dow Caroline Excel Discussion (Misc queries) 5 May 1st 09 02:19 PM
Create a drop down list in Excel with 2 different work sheets Lukas Schenker Excel Discussion (Misc queries) 3 January 22nd 09 10:59 AM
Create a list in a drop down dependent upon another dd list in exc fyrefox Excel Discussion (Misc queries) 1 August 9th 07 08:46 PM
Create a drop down list dependent on selection from another list rosiep Excel Programming 2 March 30th 07 08:22 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017