B
BabyMc
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
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