Drop down list for weekly calculation

[fragment]

Hello!

I have to update a weekly report that has a basic layout of something like this as headers:

Budget WW01 WW02 WW03 WW04 WW05 WW06 WW07 WoW QoQ YoY

And I update the work week (WW) to reflect where actual is trending to the budget. For example, let's say I switch from WW01 to WW02 the next week, but I have to update Week Over Week (WoW), Quarter of Quarter, etc. manually to reflect Budget minus WW01 to Budget minus WW02 and so forth.

I want to build in a drop down that lets me select a WW and have the calculations in WoW and QoQ and YoY adjust accordingly.

Is there a way to do this?

 

[awoohaw]

welcome to the forum. Can you post a mini workhsheet using the xl2bb add in (link below). Expected results would be helpful. Thanks,
if you cann't post using xl2bb please post a table with the row/column headers, not an image.

 

[fragment]

welcome to the forum. Can you post a mini workhsheet using the xl2bb add in (link below). Expected results would be helpful. Thanks,
if you cann't post using xl2bb please post a table with the row/column headers, not an image.

Book1
	A	B	C	D	E	F	G	H	I	J	K
1				Weekly Trend
2		Actual'23	Budget'24	WW01	WW02	WW03	WW04	WW05	WW06	WoW	YoY
3	Division A	218	926	154	962	575				-387	357
4	Division B	463	97	239	331	199				-132	-264
5	Division C	506	499	286	422	369				-53	-137
6	Division D	71	134	183	876	763				-113	692
7	Division E	869	122	840	641	938				297	69
8	Division F	832	742	981	819	904				85	72
9	Division G	600	330	520	805	728				-77	128
Sheet1

Cell Formulas
Range	Formula
J3:J9	J3	=F3-E3
K3:K9	K3	=F3-B3

 

[fragment]

Book1
	D
11	WW04
Sheet1

Cells with Data Validation
Cell	Allow	Criteria
D11	List	=$D$2:$I$2

 

[fragment]

Book1
	D
11	WW04
Sheet1

Cells with Data Validation
Cell	Allow	Criteria
D11	List	=$D$2:$I$2

Book1
	A	B	C	D	E	F	G	H	I	J	K
1				Weekly Trend
2		Actual'23	Budget'24	WW01	WW02	WW03	WW04	WW05	WW06	WoW	YoY
3	Division A	218	926	154	962	575	621			-387	357
4	Division B	463	97	239	331	199	460			-132	-264
5	Division C	506	499	286	422	369	746			-53	-137
6	Division D	71	134	183	876	763	103			-113	692
7	Division E	869	122	840	641	938	621			297	69
8	Division F	832	742	981	819	904	480			85	72
9	Division G	600	330	520	805	728	851			-77	128
10
11		Pull down to update WoW/YoY to use specific WW, for example WW04 when I update weekly numbers		WW04
12
13
14
15
Sheet1

Cell Formulas
Range	Formula
J3:J9	J3	=F3-E3
K3:K9	K3	=F3-B3

Cells with Data Validation
Cell	Allow	Criteria
D11	List	=$D$2:$I$2