Michael_adams_'s List: Excel

The ss tag preserves internal spaces, so the column alignments are maintained. Note that the text is inside the first tag, after the = sign, and followed by the closing brace, asterisk, and closing tag.

When you paste from Excel into the message window, tabs are inserted where the column breaks were, so you're somewhat at the mercy of HTML for whether the resulting tabulation exactly fits your columns. Even so, it's a welcome addition when uploading a spreadsheet is overkill.

For a faster alternative, use the routine below. Select the data you want to paste from Excel, run the sub (which formats the data, adds the tag, and copies the result to the clipbard), and just paste (Cntl-V) into the Oz message window. It maintains column alignment, and shows row and column headers

This article describes a method to register one's UDF with Excel so it shows up in a category of your choice, with argument descriptions as well as:

Custom category created by technique described in the article. Argument descriptions created by technique described in the article.

This shows a nifty way to implement a Pivot Table to reconcile many accounts. The basic concept is fairly simple to implement so long as you can get your two data sources in electronic format.