I'm losing my mind. Please help. I have multiple sheets, each sheet contains the name of the Court Reporter with their due dates for transcripts. Sheet One is title Court Reporter just making it easier for me to click on their name and it will take me directly to their sheet.
So when a DUE DATE has approached it will highlight in RED but I also want it to be automatically be moved when it comes due to one sheet. I have 30 sheets and if 5 out of those Court Reporter's have dues then I want to be able to see it in one sheet opposed to clicking on each reporter to see what they have due. I hope this makes sense. I am attaching my WORKBOOK.
I want to be able to see what is due for each reporter on one sheet when it COMES DUE opposed to clicking on each sheet. HELP!
Is there a code for this?