CODEWITHSUNDEEP
vbaexcel
user3729199
user3729199

Reputation: 85

Excel: Creating a dropdown using two different ranges

I have following threes excel sheets in a single workbook:

  1. Range1_Sheet (A1:A5 contains the data that need to be displayed in drop-down)
  2. Range2_Sheet (A1:A5 contains the data that need to be displayed in drop-down)
  3. List_Sheet (This sheet shows a drop-down containing all values that lie in above two ranges).

I successfully did this using one range/sheet. But i was wondering how list can be populated from two different sources?

Upvotes: 3

Views: 4122

Answers (1)

Irithyll
Irithyll

Reputation: 90

Here's the same question but only an answer for Google Spreadsheet Can I create a drop down list with data from multiple sheets

Try this - Data Validation: http://www.contextures.com/xlDataVal05.html

Maybe this? http://ccm.net/faq/15543-excel-creation-of-dropdown-from-dynamic-list-in-vba

It explains the way with 2 different workbooks but should work with just one workbook and multiple Sheets, too.

Upvotes: 1

Related Questions