Good day, I have a spreadsheet that is produced by a macro, with a variable number of rows that must be divided into two sections by the criteria in one column, using another macro. Each section must then have "subtotals" below each column. Further Information:
Each Row contains data on 1 transaction
Column A contains Salesperson Name (of which there are only two, lets say "Joe" and "Bill")
Columns B through F contain dollar amounts describing aspects of each transactions (like base price, discount, upgrade price, sales tax, etc.)
I need all of Joe's Sales listed first, with "subtotals" of each column below the list, followed by an empty row and then all of Bill's sales with "subtotals" of each column below the list.
I have tried declaring variables for the range of the first column to be subtotaled, the range of the cell to place the result, and the range of the row that I want to "drag" the formula across. However, I am getting a fixed cell reference for the range of the column to sum, so that when I try to autofill the results across the other columns I get the same value as the first column.
Any help would be appreciated!