Excel Magic Trick 324: Dynamic Data Validation List of Dates

[ajsady]

woow...!! cool...i never try this trick..awesome..

well, can i learn some trick excel 2007 from u??

[ExcelIsFun]

This is an Excel 2007 trick.

[BAINBRYAN]

With Data Validation does to List items need to be in the same sheet or can the List items be in another sheet with in the same workbook. (i.e. the data validation drop down menu is in Sheet 1 A1 and have the list items on Sheet 2 A1:A15)

[ExcelIsFun]

Try this videos:

Excel Magic Trick 548: Data Validation Drop-Down List In A Cell Same Sheet or Different Sheet

[kayno9]

Excellent trick!

[ExcelIsFun]

Dear kayno9,

Thank you!

--excelisfun

[ziggle314]

Hi Mike,

I agree with tirathmistry. Your work is superb.

Zig

[ExcelIsFun]

Dear ziggle314,

Thank you very much! Excel is so much fun and I enjoy making the videos, so I'll keep making more!

--excelisfun

[tirathmistry]

Awesome tutorial video ExcelIsFun You are genus really You are No 1 tutor You are Awesome person Your all video tutorials are valuable to all Lerner of excel really Thanks to your kind effort for making tutorial videos from us Your all excel tutorials video are very useful & very powerful very detail & Nicely explain Really people like you who made youtube more popular more interesting & valuable Keep up good work Thanks a Lot With Lot's of Love & Blessing God Bless you

[ExcelIsFun]

Dear tirathmistry,

Thank you for the compliments!

But remember, I am just a guy having fun with Excel. The Smartest Excelers around are at the Mr Excel Message Board!

--excelisfun