How to prevent duplicate entries in Excel using VBA

If you are serious about storing information in MS Excel, it is important that you set up your data correctly from day one. By preve...