Sub to bring to data to table
I have a PT(table1) and use GETPIVOTDATA to fill Column I + Column J
I want to be able to summarise the results in table 2
So you can see that there is the ref errors which will always be there, is there a sub i could use to bring these neatly into the table.
The way the data comes in and is set up it will always be numbers, ref error, numbers, ref error etc
Thanks
Seamus
test.xls
I want to be able to summarise the results in table 2
So you can see that there is the ref errors which will always be there, is there a sub i could use to bring these neatly into the table.
The way the data comes in and is set up it will always be numbers, ref error, numbers, ref error etc
Thanks
Seamus
test.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ive done the table from the pivot
Thanks
Rory!