| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
filtering multiple spreadsheets
I have many spreadsheets each for one company of a group.
Currently I filter each spreadsheet at a time when I want to see the relevant area. Is there a way to filter each company's spreadsheet with only one action on the parent company's spreadsheet? Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
filtering multiple spreadsheets
You can use code to open each workbook and do the filter action.
Or do you have all workbooks open ? What do you want to do (only view the data) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Yiannos" wrote in message ... I have many spreadsheets each for one company of a group. Currently I filter each spreadsheet at a time when I want to see the relevant area. Is there a way to filter each company's spreadsheet with only one action on the parent company's spreadsheet? Thank you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
filtering multiple spreadsheets
The data is in one workbook in several similar sheets, each company in one
sheet. In each sheet I have used autofilter, to filter to the areas I want to view. The problem is that I need to filter each company (i.e. sheet) separately. Is there a way to filter all the sheets in the workbook with just one action? Thank you "Ron de Bruin" wrote: You can use code to open each workbook and do the filter action. Or do you have all workbooks open ? What do you want to do (only view the data) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Yiannos" wrote in message ... I have many spreadsheets each for one company of a group. Currently I filter each spreadsheet at a time when I want to see the relevant area. Is there a way to filter each company's spreadsheet with only one action on the parent company's spreadsheet? Thank you |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
filtering multiple spreadsheets
This is a basic example that filter on the first column of the CurrentRegion of A1
Sub Test() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets ws.AutoFilterMode = False ws.Range("A1").CurrentRegion.AutoFilter Field:=1, Criteria1:="yourfilterword" Next ws End Sub Record a macro when you filter one sheet and look at the code -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Yiannos" wrote in message ... The data is in one workbook in several similar sheets, each company in one sheet. In each sheet I have used autofilter, to filter to the areas I want to view. The problem is that I need to filter each company (i.e. sheet) separately. Is there a way to filter all the sheets in the workbook with just one action? Thank you "Ron de Bruin" wrote: You can use code to open each workbook and do the filter action. Or do you have all workbooks open ? What do you want to do (only view the data) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Yiannos" wrote in message ... I have many spreadsheets each for one company of a group. Currently I filter each spreadsheet at a time when I want to see the relevant area. Is there a way to filter each company's spreadsheet with only one action on the parent company's spreadsheet? Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple worksheet filtering | Excel Discussion (Misc queries) | |||
| Filtering spreadsheets | Excel Discussion (Misc queries) | |||
| filtering between spreadsheets | Excel Worksheet Functions | |||
| Filtering for multiple sheets | Excel Discussion (Misc queries) | |||
| How to update multiple links in multiple spreadsheets followin mo. | Excel Worksheet Functions | |||
Hybrid Mode
