Hello,
Using an Excel 2016 pivot table, I need to select the range with a dynamic start cell to the last column (which also may change because of the start cell changing). The first row contains the column headers that change (-2, -1, 0, 1, 2,3, through 30, etc.) - any of these headers can change.
The following rows contain results that that I need to total from 7 through the last column.
So I need the range to start a 7 and go to the last column.
Is that possible?
Thank You,
Using an Excel 2016 pivot table, I need to select the range with a dynamic start cell to the last column (which also may change because of the start cell changing). The first row contains the column headers that change (-2, -1, 0, 1, 2,3, through 30, etc.) - any of these headers can change.
The following rows contain results that that I need to total from 7 through the last column.
So I need the range to start a 7 and go to the last column.
Is that possible?
Thank You,