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?

Check out Ron's page:

http://www.rondebruin.nl/copy5.htm
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Karen" wrote:

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?

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
Microsoft MVP Excel
SalesAid Software

"Karen" wrote in message
...
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?

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


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
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
Microsoft MVP Excel
SalesAid Software

"Karen" wrote in message
...
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?