http://www.techonthenet.com/excel/macros/index.php

Excel Topics: Macros

--------------------------------------------------------------------------------

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

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

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