Hi

Can anyone help me?? I know what I wanna do in terms of logic, but I need to translate it into excel speak!!!

I want to

Find lesson where date =' ' and per =''

The main issue is that I am trying to search 10 worksheets for date and per columns and display the lesson column in a new worksheet!!

Can I do this in excel??

Thanks