Hi,
I have a column in my sheet which has values between 1 and 200. I need to produce a summary but am using code so wondered whether it was more efficient to create a pivot table and take the values from that or whether to load the values into a collection.
Does anyone know the pros/cons of each method?
Thanks
Nick
I have a column in my sheet which has values between 1 and 200. I need to produce a summary but am using code so wondered whether it was more efficient to create a pivot table and take the values from that or whether to load the values into a collection.
Does anyone know the pros/cons of each method?
Thanks
Nick