Hyperlinks:

• Extract hyperlink address (web addresses ONLY) in Excel 2003/XP/2000/97
• Extract hyperlink address (files and web addresses) in Excel 2003/XP/2000/97
• Filter final series of numbers in hyperlink address in Excel 2003/XP/2000/97
• Delete all hyperlinks on a sheet in Excel 2003/XP/2000/97
• Update cell based on hyperlink selected in Excel 2003/XP/2000/97
• Create hyperlinks to link cells in column E to their matching value in column C in Excel 2007

Visual Basic Editor:

• Open the Visual Basic Editor in Excel 2007

Checkboxes:

• Update a cell when a checkbox is clicked (Forms toolbar) in Excel 2003/XP/2000/97
• Update a cell when a checkbox is clicked (Control Toolbox toolbar) in Excel 2003/XP/2000/97

Combo Boxes:

• Link data to a combo box and update underlying data in Excel 2003/XP/2000/97

Integration with E-mail:

• Email the active worksheet in Excel 2007

Test for duplicates:

• Test for duplicates in a column in Excel 2003/XP/2000/97
• Test for duplicates on partial cell contents in a column in Excel 2003/XP/2000/97
• Test for duplicates in two columns, combined in Excel 2003/XP/2000/97
• Test for duplicates in eight columns, combined (and delete duplicates) in Excel 2003/XP/2000/97
• Test for duplicates in eight columns, combined (and delete duplicates and originals that were duplicated) in Excel 2003/XP/2000/97
• Test for duplicates in eight columns, combined (and clear the values in the 8 columns when a duplicate is found) in Excel 2003/XP/2000/97
• Create a column that must contain unique values in Excel 2003/XP/2000/97

Test and copy data:

• Test each value in column A until a different value is found in Excel 2003/XP/2000/97
• Test each value in column A and copy matching values into new sheets in Excel 2003/XP/2000/97
• Test each value in column A and copy matching values into new workbooks in Excel 2003/XP/2000/97
• Test each value in column A and copy matching values into new workbooks (name workbooks the value found in column A) in Excel 2003/XP/2000/97
• Copy the value in Column B the number of times indicated by the value in Column A in Excel 2003/XP/2000/97
• Copy range of cells from one sheet to another sheet matching on date values in Excel 2003/XP/2000/97
• Search for a value in a column and copy row to new sheet for all matching values in Excel 2003/XP/2000/97
• Enter a value in an InputBox and then search for this value in a column and copy row to new sheet for all matching values in Excel 2003/XP/2000/97
• Copy data to various sheets based on the value in column A in Excel 2003/XP/2000/97

Update formulas:

• Update all formulas to reference data in a particular column in Excel 2003/XP/2000/97
• Update all formulas to reference data in a particular row in Excel 2003/XP/2000/97

Integration with Access:

• Open an Access Form from Excel 2003/XP/2000/97

Custom Math Functions:

• Creating a custom round function in Excel 2003/XP/2000/97
• Creating a custom average function (that excludes outlyers from the calculation) in Excel 2003/XP/2000/97

Check if files exist:

• Check to see if a file exists based on a value in column A in Excel 2003/XP/2000/97
• Check to see if files exist based on values from 2 columns in Excel 2003/XP/2000/97

Miscellaneous:

• Test range of cells for formulas (or missing formulas) in Excel 2003/XP/2000/97
• Automatically refresh pivot table when data in a sheet changes in Excel 2003/XP/2000/97
• Automatically refresh pivot table when user switches between sheets in Excel 2003/XP/2000/97
• Link one cell to another cell (control the recalculation) in Excel 2003/XP/2000/97
• Change the background color of a row based on a cell value in Excel 2003/XP/2000/97
• Change the background color of a cell when another cell is selected in Excel 2003/XP/2000/97
• Macro to warn when a record will expire within 31 days in Excel 2003/XP/2000/97
• Convert currency into words in Excel 2003/XP/2000/97
• Overwrite column B value when column A value is higher in Excel 2003/XP/2000/97
• Function to calculate total cost based on a tiered fee structure in Excel 2003/XP/2000/97
• Autonumber a cell each time the spreadsheet is opened in Excel 2003/XP/2000/97
• Convert an entire spreadsheet to proper case in Excel 2003/XP/2000/97
• Convert an entire spreadsheet to uppercase in Excel 2003/XP/2000/97
• Create custom function to exceed 7 nested If functions in Excel 2003/XP/2000/97
• Create a control screen to maintain data on another sheet in Excel 2003/XP/2000/97
• Counting matched pairs in Excel 2003/XP/2000/97
• Perform a lookup where the reference value is stored somewhere in a string in Excel 2003/XP/2000/97
• Cleanup an export of raw data in Excel 2003/XP/2000/97
• Rearrange data in an export of raw data in Excel 2003/XP/2000/97
• Create a File SaveAs macro in Excel 2003/XP/2000/97
• Test a string for an alphanumeric value in Excel 2003/XP/2000/97
• Automatically open a Form when spreadsheet is opened in Excel 2003/XP/2000/97
• Count the number of cells with a particular font color in Excel 2003/XP/2000/97