Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
search for records | Excel Discussion (Misc queries) | |||
How to show the figure of the filtered records ? | Excel Discussion (Misc queries) | |||
search for a name from list and then go to relevant records | Excel Discussion (Misc queries) | |||
search and export multiple records | Excel Worksheet Functions | |||
How to Show Records with No Data.......... | Excel Discussion (Misc queries) |