I'm trying to find a code that will search thru named sheets depending on what the user picks from the userform. Right now I have it entering data in named sheets depending on what the user picks. So in column B in a named sheet say "Sormin" it will enter the data in cell B6 "John" based on the userform drop down box. I want to search whats in cell A6 from that sheet in different named sheets. In Column A each cell has a time. So I'd like to search and see if cell B5 and cell B7 are empty in the other named sheet the user will pick from a drop down box.

If they aren't empty then I will return an error. If one or both are empty then do nothing.

Any help is appreciated.