Data Validation 2 - Create Drop Down Menus From Source Data on Separate Tabs in Excel

Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials.

Create drop down menus in Excel with source (list) data from separate tabs within Excel. This Excel video tutorial shows you how to create a drop down menu that uses data from separate worksheets within Excel. This is a great tutorial to view because of the fact that you can just point to a range in a separate worksheet in Excel through data validation. Instead, you have to use named ranges with data validation in order to reference data that is not on the same worksheet as the drop down menu that you want to create.

For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!

Category:

Education

Tags:

• excel
• drop down
• menu
• lists
• separate
• worksheets
• tabs
• data validation

[ExcelisHell]

@ShadowKiller1971 That's a great tip!  I'll put it in a tutorial for everyone!

[ShadowKiller1971]

Don't know if this is useful to anyone, but you can create your drop-down list values on on sheet, then copy and paste it to another. It still works.

[ExcelisHell]

@dianeziesing Send me a pm, could be for a number of reasons.

[dianeziesing]

I did as you describe in this video but I am getting the error message "The list source must be a delimited list, or a reference to single row or column" when I enter the Source (=the name of my list). Any suggestions?

[ExcelisHell]

Thanks for all the great comments ! I'm glad you like the videos :)

[tirathmistry]

Awesome tutorial. Great work

Thanks a lot on your tutorials, they are really nice and understandable & Valuable for us, you helped me a lot to become better with using Excel. you are Genus person

Thanks for all the tutorials & kind effort

Keep up the good work!

God bless you :-)