adding ranges

A

agw8

how do i make a button that adds
two ranges together
i.e
adds a1 to c1, a2 to c2 etc..
and places these values in the "a" column where the previous values were
 
B

B. R.Ramachandran

Hi,

Even though the following approach doesn't 'create a button' to do what you
want, it nevertheless achieves your objective.

Select and copy Column C --> Select Column A (note that the selections
should be of the same size) --> "Edit" --> "Paste Special" and check "Add"
(under "Operation") --> "OK"

Please note that the original contents of Column A are overwritten by the
new values; so you won't have a record of the old data (of course, you can
get them back by doing the reverse)

Regards,
B. R. Ramachandran
 
Top