Can you post an example workbook (manage attachments) showing what you have and what you want to happen? That will help me. It sounds like you will need to just repeat pertinent lines of code for each of your three categories.