This video tutorial features VBA code that creates a new worksheet for each unique item that it finds in a list and then copies that record to the new sheet. In the featured scenario we have a thousand transaction records.  The VBA code creates a new worksheet for each branch location that it finds in… Read More »Excel VBA: New Worksheet For Each Unique Item in List & Copy Record

 This tutorial demonstrates how to automatically protect data immediately after it has been entered in a cell.  The steps are: Unlock all cells in the worksheet. To do this select all cells (click in an empty cell and use the shortcut CTRL A to achieve this) Open the Format Cells dialog (CTRL 1 will… Read More »Automatically Lock Cells After Data Entry