saw your reply to my post. as a novice, i'll appreciate a bit more education. should i copy and paste the formula into worksheet 2? just that?
Grazie (thanks), regards from a very hot and humid Florence. Stefano
You helped me on this a while ago, any reason why the green and blue isnt auto sorting with its corresponding colored table at the bottom? I keep getting REF! errors http://www.excelforum.com/attachment...ason3test2.xls