This doesn't do everything you're after, it doesn't put in the borders and it doesn't merge any cells, which is something I would avoid.
In the code you'll need to change the location for your text file.
I'm sure somebody else will have better ideas of how to do this but until then I hope this is of some use.
Good Luck
NoSparks
|