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