Home / Macros

Macros

To Do List for Multiple People

Using the Free To Do List Template change the update routine to allow for multiple worksheets to be created for different people.

Read More »

Split Row Into Multiple Rows

For this request we needed to loop through a number of rows and where candidate data was separated by a comma split the text into however many separate values are found between the comma’s. As part of the split process to also divide an amount by the number of candidates to be split

Read More »

Highlight a Row based on Values in the Row

Request was received to highlight rows dependent on values in specific columns of data. A macro was developed to run through the worksheet and set a value and format for the rows based on the compared columns of information.

Read More »

CTRL+F1 to Hide the Excel Toolbar using VBA

There are a number of options to solve this problem, the simplest approach we found for this request was the combination of the "SendKeys" function and the Workbook_Activate procedure. Basically we created a routine that would Hide the Toolbar each time the workbook was activated. Then when the workbook was closed or de-activated it would reset the Toolbar to the original state.

Read More »

Transfer most Recent Records

A macro developed to compare rows of data and then transfer unique rows from the source worksheet into a result worksheet. This can be applied across many different uses in other spreadsheets.

Read More »

Shortcut to Last Worksheet used

The Excel Help Desk received the following request for help....Is it possible to define any shortcut (key sequence) in order to be able to quickly switch between last used sheets which are not next to each other - preferably using only left hand

Read More »

Find Duplicates in Multiple Worksheets

What is the best way to find duplicates in a workbook with over 40 worksheets? This workbook has over 5,000 names separated into different groups (worksheets). We use this list as a basis for invitation lists. We usually have over 100 names duplicated and are trying to find the best way to highlight the duplicates - we have tried many different methods in the past, but none that finds all the dupes.

Read More »

How to print Worksheets to different Printers

The quickest and simplest way to solve this problem is by using a Visual Basic Macro. In this case we need to set specific commands to print Sheet A to one printer and then Sheet C to another printer and not printing Sheet B.

Read More »

Disable Alerts and Warning Messages in Excel

When building macros there can be times when the standard Excel warning alerts need to be disabled in order for the macro to complete it's intended function. An example may be where you have developed a macro that needs to create a temporary worksheet to store some values and then before completing the macro you need to clean-up and delete that sheet. The standard Excel warning alert would be presented unless you include some code to disable that alert.

Read More »

Prompt user to select file

The following module is an interface which prompts the user of the document to select a text file from a pop up dialog box (similar to the Open or Save As window). Once the file is selected, the pathname and document name is recorded. This pathname/filename can then be used to automatically open the text file and further coding used to import and format the data. This macro is particularly useful for reporting purposes where data is imported on a regular basis.

Read More »