Unfortunately I can't figure out how to place a screenshot of my spreadsheet to show you what I'm doing, so I'll try to describe it (I tried Mr Excel HTML Maker, but I keep ending an error in the code when I use User Defined Selection).
I recorded and edited a macro (below) that looks at the...