Installation Instructions:

1. Close all open instances of Word and Excel.
2. Run install.bat
3. Profit!

B&S Add-In To Do:

• add random sample functionality

• remove hyperlinks removes all cell formatting (color/data type/borders/etc.)

• add "Center Across Cells" functionality? (vs. merge & center)

• add ability to sync audit calendar to Outlook?

• add ability to benford to select a certain population to be copied over to a new tab (like double clicking an item in a pivot table)

• update comparison functionality to highlight items where left vs. right counts are disparate, not just unique items (eg, 2 $3s on one side and 3 $3s on the other)?

• refactor code to use programmatic menus instead of XML menus?

• feature to highlight a random sample of the selected cells

• yahoo Finance Excel macro idea ("=price()", "=sector()", "=fullname()" functions)

• beneish M-Score? (needs to be less than -2.22)

• http://www.extendoffice.com/product/kutools-for-excel.html

• change all positives to negatives, vice versa, swap signs

• combine columns into one

• convert text to number, number to text

• change the case of letters

• trim leading & trailing whitespace, unnecessary inner spaces

• reverse selection

• sort items by color

Unsolvable Problems:

• add link function should allow you to double-click an already selected cell to indicate it should be the link target
• when headers are rolled forward, can they detect it's a new year and remind users to update risk levels?
• fix =LEN() #VALUE formula error in add header function (see errors folder) (tried to fix--LEN is returning error, but no idea why and Google is no help)