I assume by PM you mean the person using the program?, why not just
filter the sheet for that user on opening and then back to all on close,
you could do it by their windows logon using
Code:
--------------------
Environ("username")
--------------------
you would of course have to hard code all their usernames or look them
up on a hidden sheet but it would be a bit smarter than having lots of
buttons.

Alberta Rose;507202 Wrote:
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 :)


--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=139450