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 :)

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

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

"Simon Lloyd" wrote:


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