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

 

[Fluff]

Ok, how about

Fluff.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1
2
3		Week Nbr	42	42	42	42	42	43	43	43	43	43	44	44	44	44	44
4			16/10/2023	17/10/2023	18/10/2023	19/10/2023	20/10/2023	23/10/2023	24/10/2023	25/10/2023	26/10/2023	27/10/2023	30/10/2023	31/10/2023	01/11/2023	02/11/2023	03/11/2023
5		dave								L		L
6		tony	L						L				L
7		matt		L		L						L
8		pablo						L
9
10
11
12
13		week nbr	42
14		This week	Mon	Tues	Wed	Thu	Fri
15		dave	0	0	0	0	0
16		tony	L	0	0	0	0
17		matt	0	L	0	L	0
18		pablo	0	0	0	0	0
Sheet5

Cell Formulas
Range	Formula
C13	C13	=WEEKNUM(TODAY())
C15:G18	C15	=INDEX(INDEX($C$5:$Q$8,MATCH($B15,$B$5:$B$8,0),0),MATCH($C$13,$C$3:$Q$3,0)+COLUMNS($C15:C15)-1)

 

[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

 

[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))