cell change
I have a range of cells that will users can put information in. If anyone of
those cells are entered then in a separate section of the same worksheet,
those numbers are used to calculate a percentage.
A B
1
2
3
4
5
Column B1 = A1 * A3
Column B2 = A5 * A2
etc etc.
I want Column B to automatically generate the answer upon a change in Column
A.
I have read that worksheet_change would work.. but i'm not sure how that
will work with implementation of change in several different cells.
Any help would be greatly appreciated.
Thanks
|