dakota
08-31-2006, 12:25 PM
I'm looking for help on a macro I'm creating for one of my files. The purpose is to download a large number of data records, sort them by common types of equipment, then copy and paste each set of sorted transactions into separate worksheets. I've been able to get that far, but the next step I want the macro to perform is to summarize all the costs (which is located in column H) and return a total 2 cells below the last data line regardless of the number of transactions.
The problem I am having is that the macro in summarizing a concrete range (H4:H14) and will never change. As the number of transactions continue to increase, this range will leave out anything after row 14. I really just want something that sums a range from the first record to the last record of the column.
Any suggestions would be greatly appreciated.
The problem I am having is that the macro in summarizing a concrete range (H4:H14) and will never change. As the number of transactions continue to increase, this range will leave out anything after row 14. I really just want something that sums a range from the first record to the last record of the column.
Any suggestions would be greatly appreciated.