I have a pivot table, which is sometimes long and sometimes short depending on the data.
I do not want to show the users that its a pivot table.
I heard that we have use Cell references.
I created a new table with My heading like Emp Id, Name... With custom formating of rows and columns.
For Example if pivot table Row Lables starts from A3 to F40.
I can use =A3, =A4 and so on...
There are 2 issues in this.
Now if the user checks the formula he will come to know that its taken as a reference.
If the pivot table is short let's say from A3 to F13, all other cells will look untidy, whats the solution for this
I do not want to show the users that its a pivot table.
I heard that we have use Cell references.
I created a new table with My heading like Emp Id, Name... With custom formating of rows and columns.
For Example if pivot table Row Lables starts from A3 to F40.
I can use =A3, =A4 and so on...
There are 2 issues in this.
Now if the user checks the formula he will come to know that its taken as a reference.
If the pivot table is short let's say from A3 to F13, all other cells will look untidy, whats the solution for this