Lookup

[Alberta Rose]

I've been struggling with this problem for awhile now. I have recorded
macros to try and get the information I need, but I think because it's
involving a filtered spreadsheet, some of the macros aren't working.

So, on to trying this - Lookup. I have a spreadsheet with +/- 75 columns
and can be up to 60 rows. The common denominator for the search I want to
use is the PM's initials. I need to provide a list per PM of his
information. And I need to attach this code (?) to a button, e.g. when they
pick their button, the "filtered" list only has their information included in
that worksheet.

The one thing that wouldn't work on the macros is to return the filtered
list to show all before returning to the Main worksheet where the buttons
reside.

Another was they could choose the job number in their filtered list and then
show all resources attached to that job number. That worked fine, but there
was no way to just "go back" to the previous screen to show their own jobs
again without going all the way back to the main screen and then going in
again.

Hope someone can help me

 

[Alberta Rose]

Thanks for the response. Yes the PM (Project Manager) is the person using
the program. This filtering would be perfect except that they have to
reassign resources to the contract numbers and if they can't choose specific
numbers that are not assigned to them yet, they wouldn't even see them upon
opening. If this was in Microsoft Access I would know exactly what to do

Laurie