Extract each mondays data to separate worksheet

[pvwebster]

Hi,

I am seeking to extract only each Monday's data from one worksheet to another worksheet and hoping someone is able to put me on the right track.

[Limor_OP]

Hi,
Please try this in B5 and drag to the right:

=IFERROR(INDEX(Daily!$B$5:$AQ$10,MATCH(Weekly!$A$5,Daily!$A$5:$A$10,0),MATCH(Weekly!B$3,Daily!$B$3:$AQ$3,0)),"")

[Fluff13]

How about in B5 dragged down & across
=INDEX(Daily!$B$5:$AQ$10,MATCH($A5,Daily!$A$5:$A$10,0),MATCH(B$3,Daily!$B$3:$AQ$3,0))

[pvwebster]

Thanks, belinda200, a great solution that showed I was well and truly on the wrong track. Thank You

[pvwebster]

Thanks, Fluff13, another great solution that works wonders. As I said to Belinda200 , I was well and truly on the wrong track and need to upgrade my skills. Thanks again

[Fluff13]

You're welcome & thanks for the feedback.