Excel Advanced Filter Update
Here's the final video update for this week -- Automatically Copy Excel Data to Another Sheet. This video now shows the steps in Excel 2010 or Excel 2007, instead of Excel 2003.
To wrap up this week of updates, here are links to a few of my previous Excel Advanced Filter articles and posts. You probably know all the basics, but maybe you've missed a few of these tips and tricks.
- Click a Map To Filter Excel Data - set up an Excel workbook so you can click on a map of the USA, and see a list of fictional doctors in the state that you selected.
- Excel Advanced Filter Complex Criteria – see examples of criteria you can use when setting up an advanced filter
- Create New Sheets from Filtered List – a macro uses an Advanced Filter to create a separate sheet of orders for each sales rep visible in a filtered list
Note: Remember -- the 30 Excel Functions in 30 Days challenge starts January 2nd. See you then!
Watch the Excel 2010 Advance Filter Video
See how to automatically copy data to a different worksheet, with an Advanced Filter, in Excel 2010 or Excel 2007.
Video Link: Automatically Copy Excel Data to Other Sheet http://www.youtube.com/watch?v=BdG43GjIwRg