Excel Topics: Macros

---

Hyperlinks:

Extract hyperlink address (web addresses ONLY)

Extract hyperlink address (files and web addresses)

Filter final series of numbers in hyperlink address

Delete all hyperlinks on a sheet

Update cell based on hyperlink selected

Checkboxes:

Update a cell when a checkbox is clicked (Forms toolbar)

Update a cell when a checkbox is clicked (Control Toolbox toolbar)

Combo Boxes:

Link data to a combo box and update underlying data

Test for duplicates:

Test for duplicates in a column

Test for duplicates in two columns, combined

Test for duplicates in eight columns, combined (and delete duplicates)

Test for duplicates in eight columns, combined (and delete duplicates and originals that were duplicated)

Create a column in Excel that must contain unique values

Test and copy data:

Test each value in column A until a different value is found

Test each value in column A and copy matching values into new sheets

Test each value in column A and copy matching values into new workbooks

Test each value in column A and copy matching values into new workbooks (name workbooks the value found in column A)

Copy the value in Column B the number of times indicated by the value in Column A

Copy range of cells from one sheet to another sheet matching on date values

Search for a value in a column and copy row to new sheet for all matching values

Update formulas:

Update all formulas to reference data in a particular column

Update all formulas to reference data in a particular row

Integration with Access:

Open an Access Form from Excel

Custom Math Functions:

Creating a custom round function

Creating a custom average function (that excludes outlyers from the calculation)

Miscellaneous:

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 color of a row based on a cell value

Change the background color of a cell when another cell is selected

Macro to warn when a record 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

Create 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 reference value is stored somewhere in a string

Cleanup an export of raw data

Rearrange data in an export of raw data

Create a File SaveAs macro

Test a string for an alphanumeric value

Spreadsheet 123 Spreadsheet Software Development

Home | About Us | Our Services | Software | Spreadsheets Library | Excel Tutorials | Useful Links | Site Map | Contact Us

Go to... Home Book Shop Spreadsheets Library Software Library Excel Tutorials

Home