VBA Code needed

[steveautsin99]

Hi

Can anyone help me with a Code to create Pivot tables and also aut filter, and how to (save,close)all the open workbooks in one shot using vba code ?

 

[tweedle]

I think we need more to work with...

For XL2007, Start with ALT L R
and go through the desired motions.
End with ALT L R