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

[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]

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

[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]

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

[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 :-)

[ExcelisHell]

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