VBA required!?

I want to setup a spreadsheet to calculate water savings. Attached is the file for the month of July. The way I have it setup right now is that when I change the year in cell "B5" (1993~2002), saving will be output in cell "B4". Then I would manually transfer this number into cells "E3:N3" with respect to the corresponding year.

What I want to do is instead of having to do it manually everytime, I want excel to automatically output these values into "E3:N3". ie. "B5" is no longer an input, input is predefined in cells "E2:N2", output will then automatically be calculated and inserted into "E3:N3".

Hope I am clear, any help is appreciated.

Thank you

Hi

Assuming that you are on sheet Saving, the code below will complete the range E3:N3.

How do you want this code to be actioned? Button on the sheet, sheet activation event???

Please Login or Register  to view this content.

HTH

rylo

Hi Rylo,

Thank you for the response. Unfortunately, I wouldn't even call myself a beginner in VBA. I am thinking F9, in addition to upon file-opening, would be a good way to activate or to re-calculate.

How is it done?

Thank you

I have setup a button for it, I think it works just fine.

Thank you very much!