I have an excel file with 2 sheets. There are 10 columns in each sheet. Columns in Sheet 1 and Sheet 2 are the same but the data is slightly different.
Is it possible to compare the 2 sheets and highlight the rows or cells with a difference? Is it possible to reach to a solution without a VBA or vbscript? Is it possible to reach to a solution using vlookup or match or conditional formatting?
Windows Explorer lets you open cabinet (cab) files like any other folder.
In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.