Sum user selections in different colums
Posted by Graham Shaw on February 15, 2001 4:34 AM
My user will be selecting multiple cells (not necessarily adjacent) in 2 different columns that should add to the same value for each column. I need a macro that checks that the total of those selected in the first column equals the value of those selected in the second column. If the totals are OK I then want to copy the values selected to another part of the worksheet.
Any help will be appreciated.