Workbook Examples

Compare list items
This example workbooks contains example macros for comparing the contents of two different worksheet ranges.
Click here to download this example.
Updated: 2002-04-02 Requires: XL97 File size: 62 kB

Close idle workbooks
This example workbook contains macros that might be useful if you have problems with users that never remembers to close workbooks they share with other users.
Click here to download this example.
Updated: 2002-01-26 Requires: XL97 File size: 12 kB

Cells with "memory"
This workbook shows how you can create cells with "memory".
If a users enters a value into a cell, the cell will display the sum of the new and old value.
Click here to download this example.
Updated: 2002-01-26 Requires: XL97 File size: 13 kB

Filter and print
This workbook demonstrates how you can filter a list for each unique item in a column and print out the filtered list. Useful for those who wish to automate the printing of simple reports.
Click here to download this example.
Updated: 2000-08-08 Requires: XL97 File size: 12 kB

Conditional formatting of cells
Conditional formatting of cells depending of their value, 3 examples.
May also be used in Excel97, but it may be easier to use the built-in functionality.
Click here to download this example.
Updated: 2000-08-08 Requires: XL5 File size: 6 kB

Copy and print
This workbook demonstrates how you can print a worksheet for each value in a list from another worksheet. The workbook demonstrates how you can get Excel to repeat a task for each item in a list.
Click here to download this example.
Updated: 2000-08-08 Requires: XL97 File size: 9 kB

Copy visible cells from a filtered list
This workbook shows how you can copy data from a filtered list to a new worksheet or a new workbook.

Click here to download this example.
Updated: 2000-08-08 Requires: XL97 File size: 7 kB

Apply a custom format to the active cell
This workbook demonstrates how you can apply a custom format to the active cell within a range.
Click here to download this example.
Updated: 2000-08-08 Requires: XL97 File size: 15 kB

Row shading
This workbook demonstrates how you can shade every other row or rows containing a value within a certain interval.
Click here to download this example.
Updated: 2000-08-08 Requires: XL97 File size: 29 kB

Worksheet map
Shows how you can create a map over cells containing numbers, text and formulas. Can be used on one worksheet or all worksheets in a workbook. Based on an example from John Walkenbach.
Click here to download this example.
Updated: 2000-08-08 Requires: XL97 File size: 38 kB

Document last updated 2002-11-21 12:43:44 Printerfriendly version

User comments:

ABJR from SPAIN wrote (2006-05-13 20:08:28 CET):

2006-05-13 EXCELENTE
LES CONOZCO DESDE 1999;
SU WEB ES DE GRAN AYUDA;
LOS EJEMPLOS SON MAGNIFICOS.
GRACIAS.

Abdoualey Mouke Yansane (of Forecariah Conakry Guinea) from San Francisco, CA, USA wrote (2005-12-30 00:52:05 CET):

Awesome
You are simply brilliant man. Neat job and really really useful tool.

I deal with formula-intensive multiple linked spreadsheets on a daily basis. This really improved my codes...

Cheers and Take Care.

turamisu nogoshiki from turkey wrote (2005-02-13 11:23:31 CET):

beautiful
very good work
i appreciate your sharing...