Chain criteria using AND

Combine criteria using OR

Select the active region

Create a filter

Find unique items using xlFilter

Restore a range or worksheet to an unfiltered state

Automate processes using Visual Basic for application code

What you should know

Determine if a workbook exists

Determine if a folder (directory) exists

Detect whether a file is open

Open a workbook

Save a workbook under a new name

Save a workbook as a CSV file

Close a workbook

Check if a worksheet exists

Create and rename worksheets

Copy a worksheet within the active workbook

Copy a worksheet to a new workbook

Move a worksheet within the active workbook

Move a worksheet to a new workbook

Move a worksheet to an existing workbook

Remove spaces from before or after a string

Use the built-in Open dialog box

Calculate data using Excel worksheet functions

Use the current date and time

Suppress and restore alerts

Create a chart

Move a chart to a chart sheet

Add or remove data series from a chart

Create a line sparkline

Create a column sparkline

Create a winloss sparkline

Delete a sparkline

Export a chart as an image

Create a UserForm

Add a TextBox to a UserForm

Add a ListBox to a UserForm

Add a ComboBox to a UserForm

Add graphics to a UserForm

Add a SpinButton to a UserForm

Create a multipage or multitab UserForm

Write UserForm data to a worksheet

Add an option button to a UserForm

Run a UserForm

Record a PivotTable configuration

Move to any PivotTable playlist position

Assign a PivotTable macro to the Quick Access Toolbar

Advance one step forward in a PivotTable playlist

Next steps