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

" wrote:

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