Forecast needs to automatically calculate based on the quarter selected by End Userg., if Q2 Closing balance after elimination should be divided by 5

[Guna13]

Hi Team,
I am new into VBA & Excel formula session
Currently, I am working on a VBA project with two columns in below name order

1. Closing the balance after elimination (Values rows)
2. Forecast (needs to be done)

If the user selects or chooses Q1, then automatically in my “Forecast” entire row will update closing balance after elimination rows / 2.

As an example, if the user selects Q4, the closing balance after elimination rows / 11 (ie 1234.00, 2 decimal format) will automatically be updated in my Forecast rows.

I would appreciate it if you could help me achieve this goal.
how to achieve, can i make choose option in my excel sheet or if any VBA code will support to this task?

B2 formula is =A2/2

Closing balance after elimination	Forecast	Final balance		Q1	Closing balance after elimination/2
882,290.45	441,145.23	1,323,435.68		Q2	Closing balance after elimination/5
(882,290.45)	(441,145.23)	(1,323,435.68)		Q3	Closing balance after elimination/8
13,056.00	6,528.00	19,584.00		Q4	Closing balance after elimination/11
(1,996,555.46)	(998,277.73)	(2,994,833.19)		Prefinal	Closing balance after elimination Values
1,996,555.46	998,277.73	2,994,833.19		Final	Closing balance after elimination Values
(13,109.58)	(6,554.79)	(19,664.37)
13,109.58	6,554.79	19,664.37
(42,909.01)	(21,454.51)	(64,363.52)
42,909.01	21,454.51	64,363.52
(49,274.89)	(24,637.45)	(73,912.34)
52,816.76	26,408.38	52,816.76
(69,899.98)	(34,949.99)
326,868.99	163,434.50
(326,868.99)	(163,434.50)