VBA help - undo search and show all records
 

In my file I have multiple worksheets. On sheet "Main", I have buttons set
up for each Project Manager that when pressed goes to the sheet "Database"
(which is a filtered list) and only shows the contracts and info that are
assigned to that PM. In a column called Job Number is listed all the
contracts. When you click on the drop down box in this column, all contracts
are listed that belong to that PM and I can select an individual contract
number. Because other resources other than PM are attached to these numbers,
I want to be able to bring up all resources attached to this contract when a
specific number is selected. I have done this via a "Show All" button.
Problem is this, after pressing the Show All button, I cannot go back to the
previous screen that shows only this PM's contracts. When I hit the drop
down button, ALL contracts in the spreadsheet are there, not just the ones
for that PM. Anyone help me?