Lookup

A

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

Simon Lloyd

I assume by PM you mean the person using the program?, why not jus
filter the sheet for that user on opening and then back to all on close
you could do it by their windows logon usin
Code
-------------------
Environ("username"
-------------------
you would of course have to hard code all their usernames or look the
up on a hidden sheet but it would be a bit smarter than having lots o
buttons
I've been struggling with this problem for awhile now. I have recorde
macros to try and get the information I need, but I think because it'
involving a filtered spreadsheet, some of the macros aren't working

So, on to trying this - Lookup. I have a spreadsheet with +/- 7
column
and can be up to 60 rows. The common denominator for the search I wan
t
use is the PM's initials. I need to provide a list per PM of hi
information. And I need to attach this code (?) to a button, e.g. whe
the
pick their button, the "filtered" list only has their informatio
included i
that worksheet

The one thing that wouldn't work on the macros is to return th
filtere
list to show all before returning to the Main worksheet where th
button
reside

Another was they could choose the job number in their filtered list an
the
show all resources attached to that job number. That worked fine, bu
ther
was no way to just "go back" to the previous screen to show their ow
job
again without going all the way back to the main screen and then goin
i
again

Hope someone can help me :
Click to expand...

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com
 
A

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
 
Top