Maintain - AutoFilter and Subtotals selection/layout?

7

7777

Hello, in utilizing Excel's 2 built in tools of:

File -> Filter -> AutoFilter

....and...

File -> Subtotals

is it possible to keep the specified selected items and layout for these in
kind of linking to other .xls files? New weekly .xls files (example:
Sales_September_20_2009_through_Septemeber_26_2009.xls and so on...) will be
created each beginning of the week in having new weekly data in which
wondering how to use all weekly .xls files with different names instead of
doing it each time within each new .xls weekly file? Thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Checking limit values from separate xls file 0
Macro Pause to Select range then Subtotal 0
Excel 2013: AutoFilter and SUM() 1
MACRO HELP WITH SUBTOTAL AND RANGES 2
Excel 2013 1
auto count-if with subtotal's autofiltered layout 7
vba to copy data from sale receipt to next available column in aninventory worksheet 0
Select rows based on criteria 4

Top