Need help with adding up automatically

Hello forumers,

help.jpg

I would like to create a macro which would keep adding numbers for further periods. Example: If I click on week, it would allow me to enter a new number. New number would be added automatically to period, quarter, year as well.

Could somebody help me out please?

Very appreciated and thankful
Edgar

Hi,

use worksheet event Change …