Extract data from Large table

Hello everybody

I have two sheets one main for large table named "Data" have all days of the weeks for all subjects and all teachers.
In sheet "CLT" I want to extract data based on sheet "Data"

The expected result for one day is explained in my attachment

Can you help me please ?

Is it difficult or unclear? Please any reply

Please anybody help me about that.. Even if an idea

Mr. xladept

Thank you very much for offering help to beginners such as me
Thank you very much for that smart code I tested it . At first it was fantastic but after I fill the whole table in Sheet "Data" with some data
I got an error.. Look at the attachment

Originally Posted by xladept

Hi Yasser,

I'll look at it tomorrow.

Thanks Mr xladept I appreciate your help and your time
Take your time .. My professor

Hi YasserKhalil,
as an option

Please Login or Register  to view this content.

thanks Mr. nilem for offering help
I tested your code but the results are not correct.. I change my cell to "4A" .. got some results not all results and the some are not correct

Oh, my mistake
please try again

Please Login or Register  to view this content.

Originally Posted by nilem

Oh, my mistake
please try again

Please Login or Register  to view this content.

Really fantastic ...
Wonderful
I appreciate your time spended on that code!!
Just one last request I promise

Simple explanation of the code .. It deserves to be studied well

Originally Posted by xladept

Attachment 359050

Hi Yasser,


You're welcome - Here's the code:

Please Login or Register  to view this content.

I appreciate yout time and effort My professor . Thank you is not enough to thank you for what you have offered me here and there