Re: Highlight used cells for pivot report selection
Thanks for trying, i just cant seem to get it to work. When it does work, ive had to change all the 'text to numbers' with that little diamond square that pops up.
The main problem is how the data is being copied i think. All the data is stored on a sheet named 'Data'. It is copied over using this formula..
The original data has no problems in how the numbers are stored, so no green triangles.
But after its been pasted into data2 for my operation the whole list has green triangles and thats why the pivot table isnt working, it displays nil values.
Is there a special paste thing i need to add onto that code because i cant figure this out.