Hide Columns, Filter & Copy Visable to new wrkbk

Ok so here is my problem...I supervise a team...I have an Excel sheet with all client information...For clinical supervision I want my team members to open their own "Supervision.xls" and click a button...this button will open "Client.xls" and select "Client info sheet"...It will then hide rows c,d,g & f...it will then filter column "e" based on the specific caseworkers name ( say "Joe") and copy only the visable columns back to their "supervision.xls" Values only (doesn't effect the colour formating of Supervision.xls) then close "Client.xls"

Help please....

So here are some sample excel sheet...they are not the real thing...mostly because they are at work and I am at home...and also the confidential issues of client info...also the data needs to be filtered by Caseworker...however the caseworker column does not need to be copied

Here are the real excel sheets for interest...
I have changed everyones surname to smith.
It is a new sheet so please excuse the lack of information.
However you should from this be able to see what I'd like.

Case worker opens supervision sheet, picks their name from drop down in "E3"
and clicks update button.

The script...filters the master list to only the clients the caseworker is working with....it then copies the information required for clinical supervision.

It would also be nice if at the end, the resulting document was automatically saved with a logical "Caseworker Name dd.mm.yyyy supervision.xls" or like name. the date could possibily be grabed from the date at the top of the page that is always "today"

Hope this helps

Not sure how I'm going to use this but I think it will come in handy

AutoFilter

Please Login or Register  to view this content.

How would return the excel sheet to normal afterwards??
Could I just change the code to:

Please Login or Register  to view this content.

or somthing to make the dropdown validation box be the filter criterial
I know it's wrong, but I'm not sure how to make it right

Also found this code:

Please Login or Register  to view this content.

Which could hide the columns I don't want to copy and then reverse it at the end of the script after the copying is done....A few more scripts needed: Copy visable and paste in correct position with out disrupting formating.

another piece of the puzzle

Please Login or Register  to view this content.

A little More

Special PAste

Please Login or Register  to view this content.

I think this will paste only the values and no formats

I can find the code but I need just a little help putting it together...as I'm now sure how to define...things like where I want it to paste etc.

I think this is the last piece...now they just need to be string together

Please Login or Register  to view this content.

Not sure how to make the parts between "???" work

Ok here is what I've got so far...but it obviously doesn't work...I don't know how I'm going make it work...but we'll get there.

Please Login or Register  to view this content.