Contextures

Excel Videos - Filters and Macros

Excel videos show how to filter data, remove duplicates, and copy macros into a workbook

Copy Macros 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 code should be pasted into a regular module, as shown in this Excel 2003 video tutorial.

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

Copy Macros from 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

Remove Duplicates from List

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 List Excel 2003

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

Filter Data to Different Sheet Excel 2003

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

More Video Tutorials

Excel Videos - Index

Macros

Mouse Shortcuts

Pivot Table Tips

Get All the Excel News

For regular Excel news, tips and videos, please sign up for the Contextures Excel newsletter. Your email address will never be shared with anyone else.

Search

Search Contextures Sites

 

Search Contextures Sites

 

Excel Tools Add-in

 

 

 

 

Excel Data Entry Popup List

 

 

 

Last updated: November 18, 2016 4:08 PM
Contextures RSS Feed