Reminder prompts using pivot table or other

[faodavid]

Hi
Im trying to set up a dash on the attached excel document which will show me various prompts form the tab DATABASE, someone mentioned pivot table would be a good solution, but I dont have the know how.

If possible I would like to have the following prompts each time i open the dash tab

Each row represents a concert

1 Cities where the deposit is overdue
2 Cities where com status reads credit
3. A table of prompts in date order for when I have to rebook a show



More than happy to look at any type of solution

Many Thanks in advance

Dave
ps I have cross posted the above at this link
https://www.excelforum.com/excel-for...ml#post4695198