Create a button to subtract cells in one row from another

[Smeghead]

Is there any way I can create a button which when clicked will subtract the values in one row from another row? For example:

A	1	1	1	1	1
B	2	2	2	2	2

I'd like to create a button which when clicked, will take each cell in the B row, and subtract the corresponding A cell from the B cell, i.e. in the example, the button when clicked will leave 1,1,1,1,1 in the B row. I would also like no action to be taken if the A row is empty. Is this a job for a macro, or would I need some code to do what I want?

[Special-K]

Macro solution, try this

Please Login or Register  to view this content.

[6StringJazzer]

This code is based on the above and has the following enhancements based on the description in the OP.

1. Declares all variables
2. Does not perform an operation if the cell in the first row is blank
3. Updates the values in the second row (code above adds a new row with the results)
4. Subtracts the value in the first row from the value in the second row (code above does the reverse)
5. Starts in column B, assuming column A is reserved for some kind of label as shown (code above starts in column A) (However, the OP may be a little confused as the row labels in the post are A and B)

Please Login or Register  to view this content.

You can create a button then associate this code with the button.

Note that this code does exactly what your example shows. It always operates on columns B:F, always in rows 1 and 2. If you want to operate on the currently selected row, or operate on however many cells are in the row instead of a fixed number of columns, the code needs to be updated.