Mark,
Welcome to the board
I recognise that code and have done many variations of it, for example here
http://www.mrexcel.com/forum/excel-q...ed-column.html
http://www.mrexcel.com/forum/excel-q...-column-3.html
You need to give us some more specific detail and some test data to work on.
Remember to reduce the amount of test data to the minimum required to demonstrate typical scenarios. Desensitize the data if necessary.
Show us clearly what you have and the results you want to achieve.
Please do not use images as we cannot copy them to a worksheet.
Instead:
Either
use an Add-In or similar tools to produce screenshots that we can copy.
-See my signature below,
http://www.excelforum.com/the-water-...ml#post4109080
or
code Alternatives:
http://www.excelfox.com/forum/showth...7-BBCode-Table
http://www.excelfox.com/forum/showth...=9804#post9804
Collection of codes here
https://app.box.com/s/zhz7awdag4nl1zs6564s9zzcwp50e4w9
After selecting a Spreadsheet range run the ' MAIN CODE in any of the modules
Basically to use those tools you highlight the part of your Spreadsheet of interest, and then run the code which copies that screenshot in a BB Code Tag type format into your Clipboard. You then paste that into the Post Editor window. When posted it comes out in a formatted table. Practice using those tools in our Test Sub Forum. To do that start a new “test” thread here and practice!!!
http://www.excelfox.com/forum/forumd...p/17-Test-Area
_....
or
Upload a File
Select the Paperclip icon above. To get the Paperclip icon in a Reply window you will need to select the Go Advanced Button
Alan
P.s. Please use Code Tags( see my signature below )
Reply With Quote
Bookmarks