D
Don
I have a sheet that has detail that has an autofilter. I can filter on name
and copy over their detail for their review. I want to see if I can on
another sheet have a list of all the names so they can use the dropdown ,
click a button that will go to the other sheet, filter by their name and copy
their data over to their own sheet.
I can see how to do it if I want to create a macro for each name, but I was
thinking if I had a drop down then the name would feed into the macro to
filter on that name, it would be easer?
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 6/17/2008 by DON SMITH
'
Sheets("Sheet2").Select
Selection.AutoFilter Field:=1, Criteria1:="Don"
Sheets("Sheet1").Select
End Sub
and copy over their detail for their review. I want to see if I can on
another sheet have a list of all the names so they can use the dropdown ,
click a button that will go to the other sheet, filter by their name and copy
their data over to their own sheet.
I can see how to do it if I want to create a macro for each name, but I was
thinking if I had a drop down then the name would feed into the macro to
filter on that name, it would be easer?
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 6/17/2008 by DON SMITH
'
Sheets("Sheet2").Select
Selection.AutoFilter Field:=1, Criteria1:="Don"
Sheets("Sheet1").Select
End Sub