Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update a autofilter sheet from another sheet
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update a autofilter sheet from another sheet
Yea , found a way around. I can update a pivot table field , then when you
double click on the total cell, it will create the detail for what you have filtered! Selection.ShowDetail = True I can live happy now.. "Don" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofilter in protected sheet | Excel Worksheet Functions | |||
how can you autofilter a spread sheet and keep your hypelinks in o | Excel Worksheet Functions | |||
Any way to autofilter at seperate points on the same sheet? | Excel Discussion (Misc queries) | |||
insert query into excell sheet to update excell sheet and pivot table | Excel Discussion (Misc queries) | |||
Sheet protection; can't use AutoFilter | Excel Discussion (Misc queries) |