Customize the Ribbon Bar in Excel 2007 and 2010
Want to impress colleagues with a macro button on the Ribbon Menu for Excel 2007/2010? Take a look at this video below for a quick start. Custom UI Editor from Microsoft Download Info http://openxmldeveloper.org/cfs-file.ashx/__key/communityserver-components-postattachments/00-00-00-02-39/OfficeCustomUIEditorSetup.zip
Quickly find matching records in Excel with a few keystrokes
Interesting article By Mary Ann Richardson November 20, 2007, 12:00 AM PST Takeaway: When you need to quickly find matching records in your data, you could sort the list, then add a filter — but you can accomplish the same thing in three steps using Excel’s shortcut keys. When you need to quickly find matching [...]
Using Index/Match to Compare Two Columns
You can use Index/Match to compare two columns of data and tag them as not matching the first column. In this example, I am using a list of SKUs from one month and comparing them to a list of SKUs from the current month and identifying “New SKUs”.