I will start by saying I did search group looking for answer to my issue,
but didn't find, or understand what I needed.
I am working on a form that will be distributed to remote plant locations.
It has VB code to change color of cells & check boxes to highlight selected
cells.
The cells in the
Are you saying that you are expecting multiple rows of data:(row 3-100) and you
want the Total Unit cell to be calculated from the total of all cells in column
A, C, E and G?
and the Cost total to be columns B, D, F and H?
If so, then you can
use:=SUM(A:A)+SUM(C:C)+SUM(E:E)+SUM(G:G)and=SUM(B:B)+
As you may see I have already used different cell reference for summing up
the UNIT and COST but I need a formula from which when I type and take the
reference of all the cell i.e. A3:H3 under the heading of UNIT and same
under the heading of COST, there must be a sum of the respective field in
th
I know I'm late to the party, but here's my thoughts:
It sounds like you have multiple sheets and you have the same macro
"worksheet macro? event macro?"
in each sheet module.
Sometimes this happens when you have a macro in a sheet module and then
copy the worksheet multiple times.
Each macro i
