I retrieve raw data which allows me to save to an excel file. However the data is save with all the item names and values separated into rows and cols. For e.g cA/r - r6 would be titled "Password Reset" 5 times, along with their related values in cB. They are more than 15 items; I would like to sum the value for individual items and exported them to a pre-defined excel worksheet for printing.

I'm new to this forum and VB scripting, however I must accomplish this task. Thank you for your help!!!!!

I think a Pivot Table would do what you want. You need a simple table with headings at the top of columns and data underneath. Select the whole data and use menu Data/Pivot Table Report and follow the instructions step by step.

It is easy to experiment to see what happens with various layouts. To change a pivot table, click somewhere on in and use Data/Pivot Table Report again.


-----------------------
Regards BrianB
Most problems occur from starting at the wrong place.
Use a cup of coffee to make Windows run faster.
It is easy until you know how.

Thanks!!! I will give it a test and let you know.

Hey BrianB!

The [u]PivotTable</u> did the trick, I tried all the types as you suggested, and the "Microsoft Excel List or database" works fine.

Now, is it possible to export the summarized data to a different worksheet?

Once again thank you for your response.