Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
I have a number of workbooks, for which I would like to refresh the data (pulling info from another workbook using MS Query) that is in each. What I wish to end up with, in each workbook: is my data refreshed; filters applied to the columns; and subtotalling applied. I had produced a macro to do this and it did seem fine until it encounters a workbook that has either filters or subtotalling already applied. My problem is that the workbooks won't always be in the same format (i.e. some will have these applied, others won't) when I want to update the information. What is the function to apply filtering and subtotalling if these are not already applied - but if they are already applied, remove them and reapply them after the data refresh? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Subtotals and filters | Excel Discussion (Misc queries) | |||
Pivot Table filters, especially DATE filters | Excel Worksheet Functions | |||
update subtotals based on filters | Excel Worksheet Functions | |||
Filters, Subtotal & Intacted Results after the filters' Removal | Excel Discussion (Misc queries) | |||
Subtotals & Filters | Excel Worksheet Functions |