Problem with Distribution Code

Dear VBA Experts
I have written a code for equal distribution of Budget Data based on condition.

The user will enter annual budget number in Column K (highlighted in Green) and based on condition in Column N (highlighted in Yellow), the data will be divided by 12 and it need to be equally distributed from Colum P to Column AA. The condition for distribution is ‘Y’ (Yes)/ ‘N’ (No).

I have also attached the sample file.Budget_Input Form.xlsm

Please Login or Register  to view this content.

Please help me with fixing this issue.

Thanks,
Nisha

Please Login or Register  to view this content.

If you want round figure, you can change this line

Please Login or Register  to view this content.