E
Ewing25
Heres what i want the macro to do.
I have a spreadsheet with 2 tabs. one named commisions and the other named
summary.
In the commisions tab there are 4 columns (Lets call them 1,2,3, and 4)
Columns 1 and 2 are non number values and 3 and 4 are columns with number
values.
At every change in Column 2 i want it to put the value next to it in column
1 and the sum of the values in columns 3 and 4 that correlate with the value
in Column2.
And i want it to display the information in the Summary Tab.
If anyone can help that would be amazing.
Thanks!
Alex
I have a spreadsheet with 2 tabs. one named commisions and the other named
summary.
In the commisions tab there are 4 columns (Lets call them 1,2,3, and 4)
Columns 1 and 2 are non number values and 3 and 4 are columns with number
values.
At every change in Column 2 i want it to put the value next to it in column
1 and the sum of the values in columns 3 and 4 that correlate with the value
in Column2.
And i want it to display the information in the Summary Tab.
If anyone can help that would be amazing.
Thanks!
Alex