Hi AM,
Thank you for your help. If I implemented this correctly it returns a blank cell if the criteria is not met. This is a step closer to what I am after. Is there any way to sort the columns into alphabetical order automatically or remove the blank cells in between cells automatically or copy it to another location without the blank cells in between? Thanks again for your assistance.