Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofilter Data to separate worksheet
If you have a macro that does automatic sort at the beginning, you could add
one line that removes existing filtering (ActiveSheet.ShowAllData). If you absolutely want a separate sheet for each Supervisor, then select all these sheets together (click on the first one, then press Shift key, then click on the last one while shift key is still pressed), then put in cell A1: =SheetMaster!A1, then extend the formula to the whole range (add plenty of blank rows at the bottom, so future additions in the master table will also appear on individual sheets. Now select the master sheet in order to deselect all the other sheets, then go to each sheet and use Data Filter Autofilter and pre-select the Supervisor name. Stephane. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofilter Data to separate worksheet
I tried both of these options... the first one... I guess I'm doing
something wrong? Do I put that command for "thisworkbook" or that particular page? Also - should it actually say "ActiveSheet.ShowAllData" or am I calling the ActiveSheet whatever the page is? (I'm sorry - I really know almost nothing about VB or macros - someone else helped me make the macro to have it sort the data alphabetically). It seemed that in order to get it to show all the rows again I had to go and UNSELECT the "autofilter" button again... With the second option - I managed to get it to copy all the data... the only problem is - it won't let me autofilter from these other pages. Because it's a formula, I presume? It has no option to filter anything... so that's not a viable solution... Thanks! :) On Jul 26, 5:36 am, "squenson" <u36146@uwe wrote: If you have a macro that does automatic sort at the beginning, you could add one line that removes existing filtering (ActiveSheet.ShowAllData). If you absolutely want a separate sheet for each Supervisor, then select all these sheets together (click on the first one, then press Shift key, then click on the last one while shift key is still pressed), then put in cell A1: =SheetMaster!A1, then extend the formula to the whole range (add plenty of blank rows at the bottom, so future additions in the master table will also appear on individual sheets. Now select the master sheet in order to deselect all the other sheets, then go to each sheet and use Data Filter Autofilter and pre-select the Supervisor name. Stephane. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting excel worksheet data to separate files | Excel Discussion (Misc queries) | |||
QUERY data range to populate separate worksheet? | Excel Worksheet Functions | |||
Copy data automatically onto a separate worksheet | Excel Discussion (Misc queries) | |||
Using a Worksheet Form to add data to a separate worksheet databas | Excel Worksheet Functions | |||
What formula will sort data in a separate worksheet%3f | Excel Worksheet Functions |