BravesPiano5
04-02-2013, 12:42 PM
I'm not certain what the issue is but attached is my workbook (this is an example...what I actually have is large and confidential). Basically, why is the "Rate" row getting separated and not combining? It's showing duplicate "rate" rows rather than having one line per rate and the sum of the cases/allowance...I've tried everything:
Ensure there are no unnecessary characters (i.e. spaces, blanks, apostrophes, etc.)
Convert all data to text
Remove everything except the pivot columnsI'm at a loss...I know the issue itself isn't entirely VBA (although I do have a macro which creates reference points and then consolidates the data into a pivot) but again I've tried everything. :dunno
Ensure there are no unnecessary characters (i.e. spaces, blanks, apostrophes, etc.)
Convert all data to text
Remove everything except the pivot columnsI'm at a loss...I know the issue itself isn't entirely VBA (although I do have a macro which creates reference points and then consolidates the data into a pivot) but again I've tried everything. :dunno