Excel Topics: Macros

Hyperlinks:
Extract hyperlink address (Web addresses only) in Excel 2003/Xp/2000/97

Extract hyperlink address (Files & Web addresses only) 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/200/97

Update a cell when a checkbox is clicked (Control ToolBox Toolbar) in Excel 2003/ Xp / 2000/97

Combo boxes:
Link data to 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/97
Test for Duplicates in Eight Columns, combined (And delete duplicates and originals that we duplicated ) in Excel 2003/Xp/ 2000/97
Test for duplicates in Eight columns, Combined ( & Clear the values in the 8 Columens 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 & Copy Data :
Test each value in column A untill a diffrent value is found in Excel 2003/Xp/2000/97
Test each value in column A & copy matching values into new sheets in Excel 2003/XP/2000/97
Test each value in column A & copy matching values into new workbooks in Excel 2003/XP/2000/97.
Test each value in column A & 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 form 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 date 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 refrence data in a particular row in Excel 2003/Xp/2000/97

Integration with Access :
Open an Access Form form 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 form the calculation) in Excel 2003/Xp/2000/97

Check if Files Exist :
Check to see if a file exist based on a value in Column A in Excel 2003/Xp/2000/97
Check to see if files exist based on values form 2 Columns in Excel 2003/Xp/2000/97

Miscellaneous in Excel 2003/Xp/2000/97 :
Test Range of Cells for Formulas (or missing Formulas)
Automatically refresh Pivot Table when data in a sheet changes
Automatically refresh Pivot Table when user Switches between sheets
Link one cell to another cell (Control the recalculation)
Change the Background colour of a row based on a cell value
Change the Background colour of a cell when another cell is selected
Macro to warm when a recorrd will expire within 31 Days
Convert currency into words
Overwrite column B value when column A value is higher
Function to Calculate total cost based on a tiered fee structure
Autonumber a cell each time the Spreadsheet is opened
Convert an entire spreadsheet to proper case
Convert an entire spreadsheet to Uppercase
Convert custom function to exceed 7 nested If functions
Create a control screen to maintain data on another sheet
Counting matched pairs
Perform a lookup where the refrences value is stored somewhere in a string
Cleanup an export of raw data
Re-arrange data in an export of raw data
Create in a File Save as macro
Test a string for an alphanumeric value
Automatically open a Form when spreadsheet is opened
Count the number of cells with a particular font color