Excel

Question

I want to create a weekly report in a month's tab, example under Jan tab, if i change to week 1, the week 1 report will show and changes when i select week 2, how do i do it? I've used combo box and data validation but the report doesnt change

Answer 1

What is the expected result? Could you show some screenshot?

Answer 2

	DAY	DATE	Target	Ans	Unans	Total	Talktime	Saved	Closed	Lateness	Hours
Agent 1	MON		1	1	1	1	0:00:00	1	1	0:00:00	0:00:00
Agent 2
Agent 3
Agent 4
Agent 5
Agent 6
Agent 7
Agent 8
Agent 9
Agent 1	Tues
Agent 2
Agent 3
Agent 4
Agent 5
Agent 6
Agent 7
Agent 8
Agent 9
Agent 1	Wed	1-Jan-25
Agent 2
Agent 3
Agent 4
Agent 5
Agent 6
Agent 7
Agent 8
Agent 9

Answer 3

Could you share a test file with some dummy data in it? Then I can have a try on it.

For sharing file, you may upload it to OneDrive or any other cloud drive and then post the link here.  *Please make sure you have removed any sensitive or private information in the sample file before uploading.