Unanswered: Creating a macro to sort and then subtotal a preselected range of data
I'm working with financial transactions, so the excel sheets I download from a system can have varying numbers of rows. My ultimate goal is to sort and then subtotal the data. Because the number of rows I want to sort and subtotal are always different, I was thinking I could make a macro that would only work off of preselected data. I can't just work off of all active cells, as there are some rows I don't want to include in the sort and subtotal (i.e. transactions past the billing date are all at the bottom and I insert 8 blank rows between transactions that will be included and those that won't...so I'm only sorting and subtotaling the rows above the 8 empty rows).
I'm new to making macros, so I've recorded the following simple macro to sort and subtotal data, however, you'll note it only works for the cells that were selected when I recorded the macro. I have a little knowledge of going in and actually manually modifying the code, so any help would be appreciated.
This is about as fancy as I've been able to get....after creating this recorded macro, I know enough to just go in and change it to "ActiveSheet" instead of the specific sheet I recorded on, so the macro works in any active sheet. I thought that was pretty cool...imagine how amazed I'll be if you can help me solve my sort and subtotal issue!!