simple reference changing weekly?

[WadeWatts]

Hi,

I am trying to pull a week data through from one worksheet to another based on current work week.

example of what im trying to do.
range C5:Q8 is manual input,
range C15:G18 is auto pulled through based on this week number.

this week is week 42, so today() falls within the week, so range C15:G18 shows the data from the input range,
next week when i opened the sheet, today() will be in week 43, i want the weeks data to be pulled through

initially i wrote =if(and(b5=b15,$c$13=weeknum(today())),c5)
seemed to work to pull through but i cant figure out the date to move


any ideas?

thanks

 

[WadeWatts]

Wow, that worked, thank you for that.
as i was replicating it i was able to follow along and see what it was doing,

amazing, i really did try to work it out myself but it was beyond me.

thanks again

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[kvsrinivasamurthy]

Try
In C15 copy to full range

=IF(INDEX($C$5:$Q$8,MATCH($B15,$B$5:$B$8,0),MATCH($C$13,$C$3:$Q$3,0)+COLUMNS($C15:C15)-1)="","",INDEX($C$5:$Q$8,MATCH($B15,$B$5:$B$8,0),MATCH($C$13,$C$3:$Q$3,0)+COLUMNS($C15:C15)-1))