Microsoft Office Forums - View Single Post - How to create a dropdown list from 2 ranges

Thread: How to create a dropdown list from 2 ranges

View Single Post

Old

06-30-2022, 07:01 AM

Are Square Are Square is offline

Are Square is offline

Are Square uses Windows XP

Windows XP Are Square uses Office 2013

Are Square uses Office 2013

Office 2013

Novice

The original poster

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