Hi, I've tried in vain to work this out myself and cannot find a thread that seems to match my query, so here goes:
I have a PivotTable that contains product codes and monthly sales, I then have a table to the right of that (no column gap) that contains various formulas. My questions is: is there a way for the table to resize with the PivotTable so that I don't have to extend the table beyond the last data entry and have a load of error values (i know I could add an iferror, but would prefer to keep the layout cleaner). If it needs a VBA option that isn't a problem, it's a VBA enabled book anyway.
Thanks in advance
I have a PivotTable that contains product codes and monthly sales, I then have a table to the right of that (no column gap) that contains various formulas. My questions is: is there a way for the table to resize with the PivotTable so that I don't have to extend the table beyond the last data entry and have a load of error values (i know I could add an iferror, but would prefer to keep the layout cleaner). If it needs a VBA option that isn't a problem, it's a VBA enabled book anyway.
Thanks in advance