Chip Pearson has lots of notes/examples here:
http://www.cpearson.com/excel/vbe.aspx

Personally, I'd rather copy the data to worksheets in a different workbook
(maybe based on a template that was set up the way I wanted) and not have to
remove any code.