Forum

That's it! The code only adds the date if the row is in the table. Thank you very much.

Thanks for the reply and code, Sunny. This isn't what I'm looking for. I would like code that references only the table data, not the entire worksheet...

Hi Olivier, I found a good solution using pivot tables that will allow you to create cascading data validation lists. No VBA required.