I am looking to create a macro to do the following and would appreciate any help.
I have a spreadsheet that is populated with information exported from a database and the number of rows varies.
I need to be able to add the text 'Total' in Column 'L' two rows after the last row of data. So if the cell in column 'A' is blank, then skip a row and add the text to the following row in Column 'L'
Then I need to do a Sum in Column M in the same row as defined above. The Sum would be =Sum(m2..X) where x is the last row that column A is not blank.
Hope this makes sense...
Bookmarks