Do you create a new sheet everyday? This can be automated with a simple bit of VBA code. The guide bellow will show you how to create a new dated sheet everyday automatically.
Databases can sometimes require a lot of information to be added to it. Manually typing these in each box can be tedious and sometimes difficult to keep organised. Using a form makes this much easier
Every Excel workbook that is more than a couple of sheets deserves a Main Menu. This makes it much easier to navigate the workbook as well as keeping the bottom tab bar nice and tidy
An easy way to protect sheets is to create a "Login" for your workbook, this can easily be achieved using VBA. Explained for people who know nothing about VBA, this guide will help you create a Login