macro for variable no. of rows

[rakeshshethia]

HI.


I am new to macros. Let me explain what I want the macros to do. The range is from column A to column O. No. of Rows are variable for different sheets downloaded from the system. As in, if the last row is at no. 30, all the columns would have data in last row at no. 30, but it is not necessarily 30 in all the excel files.


Part 1
I want to delete column B. Out of remaining columns, delete columns H to M. Now, the data in column G and H is in numbers. Column G is "Amount" and Column H is "Commission". I want the sum at the end of the respective columns.


Part 2
Later, I want the difference between the sums of Column G and Column H after 4 rows from the last row and in Column B. The adjacent cell in column A should have the text "Debit".

Part 2A
This is if I want the sum of Column G and H, however the number at fourth row from the last column is equal to the sum of G (and not the diff. as in Part 2)


I need macros for three different parts as it can be Part 1 AND either Part 2 or Part 2A in the sheet.


Please help.

 

[rakeshshethia]

I just copy-pasted this macro on my new laptop. It doesnt work. What could go wrong?
OS: Win 8