Hi everyone,

I need your help to solve a really basic problem which is driving me nuts. Basically, I have created a new Sheet in existing Excel file with two very simple tables as shown on the image beneath:

Image_1.jpg

The first table value (i.e. B1:D1) are updated o:n a regular basis whenever a new record is added in Sheet "Call_centr". Now, I would like to write a simple script, which would do the following:

a) it should copy the values from cells B1:D1 and add them to values in cells B6:D6.
b) Once the first part is done, it should set all the values in cells B1:D1 to "0".

I will assign this macros to the button on the main sheet, so whenever someone will press it, it should do the functions described above.

Thank you very much in advance