Just a short post because the article I am linking to covers this topic so well. This is very much a frequently asked Excel question.
About Microsoft’s Excel blog
Microsoft’s Excel blog has recently covered:
- and Pivot Tables.
For the macro gurus there are articles with sample code as well.
Go and dig around in there for yourself!