Using a scrollbar in the sheet
with No Comments

Using a scrollbar in Excel In this example we demonstrate the use of a scrollbar to scroll through a list of names. We also use IFERROR(), VLOOKUP(), MATCH(), COUNTIF() and a bit of VBA coding.   Download the workbook here:¬†

Create tasks in Outlook from Excel
with No Comments

This example create tasks in Outlook from Excel. The routine separates the tasks¬†depending of the Windows username so you only transfer your own tasks. The tasks are marked after they are transferred so they won’t be duplicated. Here you will … Read More