Different tables using Data Validation

[bronkista]

Hi there!

Need some help on creating a table when selecting a date from data validation list.

What I would need is that when a date is selected on the "Ticket Sheet" tab, it will display all numbers entered on that date per specific column.
If no number has been entered yet, it will bring out a fresh sheet to post numbers to.

Then on the "Summary" tab, it will count and sum up all numbers entered on a particular date.

Please help me out with this, attached is the excel file.

Thanks!

[bronkista]

UP on this thread

[bronkista]

Up again!
Any help would be appreciated.

Thanks!