Forecast needs to automatically calculated based on the Quarter Info selected by User

[Gunasekaran]

Dear Sir,

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
2. Forecast

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 this and which is the best option for User List Selection method or VBA Code to get Input Box info from End User ?

But I would prefer VBA code, if it's easy.

 

[vletm]

Gunasekaran
Sample ...

 

[Gunasekaran]

Hi Vletm Sir, Really great support and help... Million thanks to you...