Hello,
I have a list with multiple rows of data. When I place an "x" in the cell in Column A, that indicates I selected that row and a sumproduct ensues. Most of the rows are independent of each other. However, some rows are add alternates while others are mutually exclusive.
Add alternate means if I select the "add 1" row then I have to select the the "base" row (however, the reverse of selecting the "base" row does not require selection of "add 1"). In some cases there would be "add 1" and "add 2". Selection of "add 2" means "add 1" and "base" need to be selected.
Mutually exclusive means if I select "row 1" then I cannot select "row 5" or "row 13".
An event macro that knows where there is an add alternate (with precedence) or a mutually exclusive case based upon values in a hidden helper column, say Column B, would be fantastic. It ensures no base rows are missed and also ensures there are no duplications for the sumproducts that follow.
Anyone that can post VBA on the event macro I've conceptualized, thank you in advance
Jared
I have a list with multiple rows of data. When I place an "x" in the cell in Column A, that indicates I selected that row and a sumproduct ensues. Most of the rows are independent of each other. However, some rows are add alternates while others are mutually exclusive.
Add alternate means if I select the "add 1" row then I have to select the the "base" row (however, the reverse of selecting the "base" row does not require selection of "add 1"). In some cases there would be "add 1" and "add 2". Selection of "add 2" means "add 1" and "base" need to be selected.
Mutually exclusive means if I select "row 1" then I cannot select "row 5" or "row 13".
An event macro that knows where there is an add alternate (with precedence) or a mutually exclusive case based upon values in a hidden helper column, say Column B, would be fantastic. It ensures no base rows are missed and also ensures there are no duplications for the sumproducts that follow.
Anyone that can post VBA on the event macro I've conceptualized, thank you in advance
Jared
Last edited: