Hello & Welcome to the Forum,

You are going to need a macro for this and one of our forum members has written a procedure make specifically for this task...

http://www.excelforum.com/tips-and-t...-criteria.html