Hello All,
I am trying to create a workbook that will continuously add cells into certain columns based on its background color. Let me see if I can explain this better. I used VBA and entered a code found on line to allow for calculating data in cells by row according to background color. The draw back is after I enter the numbers and the background color in the cells I want I have to put a number in another cell and then click an additional cell just to get it to add up. What I would like is so that when I enter the data(numbers)in certain cells and add the background color that it will automatically add it up. I don't even know if this is possible.
the code I used was from the following site:
www.extendoffice.com/excel/1155-excel-count-sum-cells-by-color.html
any suggestions would be greatly appreciated.
I am trying to create a workbook that will continuously add cells into certain columns based on its background color. Let me see if I can explain this better. I used VBA and entered a code found on line to allow for calculating data in cells by row according to background color. The draw back is after I enter the numbers and the background color in the cells I want I have to put a number in another cell and then click an additional cell just to get it to add up. What I would like is so that when I enter the data(numbers)in certain cells and add the background color that it will automatically add it up. I don't even know if this is possible.
the code I used was from the following site:
www.extendoffice.com/excel/1155-excel-count-sum-cells-by-color.html
any suggestions would be greatly appreciated.