I'm an Access VBA programmer but have recently been asked to write Excel macros and I am lost. If I have the following data in a worksheet:
A B C
1 #1 #2 Tot
2 10 40
3 49 45
4 36 10
5 75 23
How can I write a macro that will 1. add the "tot" column to the worksheet and then add a formula to add the two numbers in the same row such that the result looks like
A B C
1 #1 #2 Tot
2 10 40 50
3 49 45 94
4 36 10 46
5 75 23 98
The macro will need to work no matter how many rows there are since the data is constantly changing. If someone could point me in the right direction I would be most grateful.
A B C
1 #1 #2 Tot
2 10 40
3 49 45
4 36 10
5 75 23
How can I write a macro that will 1. add the "tot" column to the worksheet and then add a formula to add the two numbers in the same row such that the result looks like
A B C
1 #1 #2 Tot
2 10 40 50
3 49 45 94
4 36 10 46
5 75 23 98
The macro will need to work no matter how many rows there are since the data is constantly changing. If someone could point me in the right direction I would be most grateful.