Spreadsheet Compare is a tool that will allow you to compare two Excel files. It will identify cells that have different text, formulas, calculated values and even formatting. This week we will look at how to use the tool and how it can save you hours of pain and frustration.
VBA or Visual Basic for Applications is a programming language that allows extra functionality for the Microsoft Office suite, including Excel, Word and PowerPoint. Some Examples of what you can do with VBA include adding an input form to capture data, customised formulas, and performing various activities when a user does something, such as a custom pop-up when a Word file opens.