A
Alberta Rose
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?
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?