tech on the net
Home About Us Feedback Site Map

Microsoft

Access Excel Word

Database

SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker

Language

C Language

More

ASCII Table Linux UNIX Java Clipart Joke of the Moment

Other Sites

CheckYourMath BigActivities DigMinecraft
Share this page:

MS Excel: Macros

The following is a list of topics that explain how to use Macros in Excel:

Hyperlinks

Visual Basic Editor

Checkboxes

Combo Boxes

Integration with E-mail

Test for duplicates

Test and copy data

  • Test each value in column A until a different value is found in Excel 2003 (or older)
  • Test each value in column A and copy matching values into new sheets in Excel 2003 (or older)
  • Test each value in column A and copy matching values into new workbooks in Excel 2003 (or older)
  • Test each value in column A and copy matching values into new workbooks (name workbooks the value found in column A) in Excel 2003 (or older)
  • Copy the value in Column B the number of times indicated by the value in Column A in Excel 2003 (or older)
  • Copy range of cells from one sheet to another sheet matching on date values in Excel 2003 (or older)
  • Search for a value in a column and copy row to new sheet for all matching values in Excel 2003 (or older)
  • 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 (or older)
  • Copy data to various sheets based on the value in column A in Excel 2003 (or older)

Update formulas

Integration with Access

Custom Math Functions

Check if files exist

Miscellaneous