I agree with royUK but I digress it would take me a bit to learn that method than to program it.
Although, if it works....

http://www.excelforum.com/forum-rule...rum-rules.html
10. Please acknowledge the response you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.