Search Contextures Sites

 

Learn how to create Excel dashboards.

 

Excel Tutorial Videos 04

Filter Excel Data to a Different Sheet -- Excel 2003 and earlier 
Remove Duplicates from a List -- Excel 2003 and earlier 
Remove Duplicates from a List -- Excel 2007 
Copy Excel VBA Code to a Regular Module 
Copy Excel VBA Code from a Different Workbook

Filter Excel Data to a Different Sheet -- Excel 2003 and earlier

With an Excel Advanced Filter, you can filter the data in place, or you can filter it to a different location. In this Excel video tutorial, you'll see the steps for setting up the advanced filter so the results are moved to a different worksheet, and the key steps for making this technique work.

For written instructions for this Excel video tutorial, see: Filter to a Different Sheet


Remove Duplicates from a List -- Excel 2003 and earlier

With an Excel Advanced Filter, you can filter the data in place, or to a different location. When applying the advanced filter, you can specify that you want to see unique items only. With that option selected, all the duplicates are removed from the filtered list.

For written instructions for this Excel tutorial, see: Filter Unique Records

Remove Duplicates from a List -- Excel 2007

With an Excel Advanced Filter, you can filter the data in place, or to a different location. When applying the advanced filter, you can specify that you want to see unique items only. With that option selected, all the duplicates are removed from the filtered list.

For written instructions for this Excel tutorial, see: Filter Unique Records

Copy Excel VBA Code to a Regular Module

If you copy Excel VBA code from a web site, for from any other source, you can paste it into your own workbooks. Most Excel VBA code should be pasted into a regular module, as shown in this Excel video tutorial.

For written instructions for this Excel tutorial, see: Copy Excel VBA Code to Regular Module

Copy Code from a Different Workbook

You can copy Excel VBA code from one Excel workbook to another, as shown in this Excel video tutorial.

For written instructions for this Excel tutorial, see: Copy Code From a Different Workbook

   

 

Excel Tutorial Videos 01
Excel Tutorial Videos 02
Excel Tutorial Videos 03
Excel Tutorial Videos 04
Excel Tutorial Videos 05
Excel Tutorial Videos 06
Excel Tutorial Videos 07
Excel Tutorial Videos 08 
Excel Tutorial Videos 09 
Excel Tutorial Videos 10  

       Home     Excel Tips     Excel Files     The Excel Store     Blog     Contact

 

Privacy Policy

 

Contextures Inc., Copyright © 2009.
All rights reserved.

 

Last updated: January 27, 2010 11:04 AM