Reply to thread

Message: <blockquote data-quote="Merkuri" data-source="post: 4532573" data-attributes="member: 41321">Excel can do all of that if you spend a little more time with it.  I don't remember where all of the options are (I've moved onto Excel 2007, which is significantly different, and I've forgotten where things are in the Excel 2003 menu) but if you turn on auto-filtering you can easily sort your data by whatever column you want (it's not auto-sorting, but you can add a piece of data at the end and re-sort it by the first column), and you can use conditional formatting to format some of your data based on whatever criteria you want.I attached an example.  I made it in 2007, but saved it in 2003 format.  You can click on any of the dropdown arrows on the headers to sort or filter it by whatever criteria you want.  Once you have it filtered the way you like you can print it and it should only print what you have showing.  I also applied the conditional filters you used in your example.  As an added bonus I froze the header row in place so that if you add a lot of words and have to scroll down you can still see the headers.  Excel is very powerful once you learn your way around it.  I threw that sheet together in about five minutes, but I use Excel every day so I'm very comfortable with it and know what it can and can't do.</blockquote>