Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-30-2022, 07:01 AM
Are Square Are Square is offline How to create a dropdown list from 2 ranges Windows XP How to create a dropdown list from 2 ranges Office 2013
Novice
How to create a dropdown list from 2 ranges
 
Join Date: Jan 2010
Posts: 12
Are Square is on a distinguished road
Default How to create a dropdown list from 2 ranges

I am using Excel 2016 on a Windows 10 laptop. I would like to create a dropdown list that uses the data in a Range #1 followed by the data in Range #2.

Is that possible and if so, how do I do it?

I'd be grateful for anyone's help.
RR
Reply With Quote
  #2  
Old 06-30-2022, 07:16 AM
jeffreybrown jeffreybrown is offline How to create a dropdown list from 2 ranges Windows 10 How to create a dropdown list from 2 ranges Office 2016
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

Hello,

This sound possible; however, without a sample of your data and the layout, it's hard to advise. Please post a sample of your data with a sample of what you desire as your outcome.
Reply With Quote
  #3  
Old 06-30-2022, 09:01 AM
Are Square Are Square is offline How to create a dropdown list from 2 ranges Windows XP How to create a dropdown list from 2 ranges Office 2013
Novice
How to create a dropdown list from 2 ranges
 
Join Date: Jan 2010
Posts: 12
Are Square is on a distinguished road
Default

What I'd like is a Dropdown list to include all the items in the top range in the attached followed by the list of data in the second range. I can't sort the two lists together since I want the second list to be at the bottom of the list showing up in the dropdown list.

Thanks for your help,
RR
Attached Files
File Type: xlsx Sample of Two Ranges.xlsx (8.2 KB, 8 views)
Reply With Quote
  #4  
Old 06-30-2022, 01:44 PM
jeffreybrown jeffreybrown is offline How to create a dropdown list from 2 ranges Windows 10 How to create a dropdown list from 2 ranges Office 2016
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

I suspect VBA is the only way to achieve what you desire, so why not just this?

Look in E4
Attached Files
File Type: xlsx Sample of Two Ranges.xlsx (8.8 KB, 10 views)
Reply With Quote
  #5  
Old 06-30-2022, 04:23 PM
Are Square Are Square is offline How to create a dropdown list from 2 ranges Windows XP How to create a dropdown list from 2 ranges Office 2013
Novice
How to create a dropdown list from 2 ranges
 
Join Date: Jan 2010
Posts: 12
Are Square is on a distinguished road
Default

WOW. That's works easy peasy! Thanks for your help.
RR
Reply With Quote
  #6  
Old 07-01-2022, 01:24 AM
ArviLaanemets ArviLaanemets is offline How to create a dropdown list from 2 ranges Windows 8 How to create a dropdown list from 2 ranges Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

An example how to do this without VBA!
Attached Files
File Type: xlsx Sample of Two Ranges.xlsx (17.3 KB, 12 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create a dropdown list from 2 ranges dropdown list to create tables brichigo Word VBA 8 09-04-2018 02:36 AM
Selection of a dropdown creates another dropdown wih the list krishnamurthy.ka2810 Word VBA 1 04-26-2018 11:44 PM
excel2016: can't create dropdown afik Excel 4 11-13-2016 01:38 PM
How to create a dropdown list from 2 ranges Take String of numbers, expand ranges, sort, then compress back into ranges AustinBrister Word VBA 19 08-22-2016 05:18 PM
How to create a dropdown list from 2 ranges Data Validation List based on Two Named Ranges Rich18144 Excel 4 01-14-2016 04:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:59 PM.


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