Macros

[Karen]

I am work for a construction company with several different project managers.
I am working on a spreadsheet with all incoming clients. I would like to
create a macro that automatically sorts the main spreadsheet into sub sheets
for each person based on their initials. The problem being that each job may
have more than one project manager. Does anyone know how to help?

 

[Luke M]

Check out Ron's page:

http://www.rondebruin.nl/copy5.htm

 

[Don Guillett]

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

 

[Don Guillett]

Solution to autofilter from a drop down

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Or Target.Address <> Range("c1").Address Then Exit Sub
Application.ScreenUpdating = False
ActiveSheet.Columns.AutoFit
If Target = "ALL" Then
Selection.AutoFilter Field:=3
Else
Range("C2").AutoFilter Field:=3, Criteria1:="=*" & Target & "*"
End If
Range("e4").Select
Application.ScreenUpdating = True
End Sub