Andy Pope has an alternate solution that DOES NOT required VBA, but requires modification of data tables.
http://www.excelforum.com/excel-char...sing-data.html

Lewis