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, 01:44 PM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows 10

Windows 10 jeffreybrown uses Office 2016

jeffreybrown uses Office 2016

Office 2016

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown 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

Sample of Two Ranges.xlsx (8.8 KB, 12 views)

Reply With Quote