How do I get Excel to remember my Subtotal criteria for each worksheet. When I do the set up
"At each Change in:"
"Use Function"
"Add Subtotal to:"
then hit ok it works for only that particular sheet. I have to enter all that data on each sheet.
I have other workbooks that remember these settings. Help this is very time consuming.
