Before I put effort into this tomorrow, if you can post an xls or doc or txt file of what you expect for output, that would help us help you more specifically. I know that you have put some effort into posting what you need but more feedback is needed to get a specific output.

Unless your code is close to what you need and works somewhat, it is best not to post any. It appears that you are trying to write to a text file. Your MrExcel example output had some bold format codes which can not be placed in a text file.

Also, try not to suggest a method for help. A specific solution route might solve your problem but it may not be the most efficient nor the fastest.