It is useful to verify if the input in a cell where email address should go is a valid input. In MS Excel we can use a validation functionality to perform an input validation.

In Excel 2003 you can apply conditional formatting that checks the value in one cell, and applies formatting to other cells, based on that value. For instance, let's say you need to change font colour of the entire column C in a table, if the values in column B are over a specific value.

The following code helps you to automate the routine job for saving each spreadsheet within the opened workbook as separated workbooks. It exports the spreadsheets into a specific directory - it uses the current date to create a new folder and then saves the files into it.

There are two dates fromat in MS Excel. One comes from an old version of Excel running on Macintosh Computer. The second one is the standard 1900 format, which is being used now. If you came accross the problem with converting the 1904 and 1900 dates, we bring you a simple solution.

Pivot table is an excellent feature of MS Excel and can be used in many different ways. If you use Pivot Tables frequently you probably realised it is not very handy to copy the data out of the pivot table and then go line by line and fill all the gaps in the columns from Row Fields.

If you need to add a new sheet with a specific name, try use the following vba code.

This is a handy VBA script that assignes a keyboard shortcut to Paste as Values action in MS Excel. We recommend to save this script within your Personal workbook, so it load every time you open your MS Excel.