How to create a dropdown list from 2 ranges

		Microsoft Office Forums > Microsoft Excel > Excel
How to create a dropdown list from 2 ranges

06-30-2022, 01:44 PM

jeffreybrown jeffreybrown is offline

Windows 10 How to create a dropdown list from 2 ranges

Office 2016

Expert

Join Date: Apr 2016

Posts: 673

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

Look in E4

Attached Files

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
Take String of numbers, expand ranges, sort, then compress back into ranges	AustinBrister	Word VBA	19	08-22-2016 05:18 PM
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 01:08 AM.