Search found 1 match

by PHRoche
Fri Jul 31, 2015 6:02 pm
Forum: Technical / Scripting
Topic: I need help creating a pivot table in VBScript
Replies: 1
Views: 5218

I need help creating a pivot table in VBScript

I hope someone can help me. I have a VBScript program to read a flat delimited file into Excel and then try to create a pivot table. My data looks a bit like this: Segment Amount 1 Amount 2 Corp 100.00 100.00 Elect 200.00 200.00 Corp 100.00 0.00 Elect 100.00 50.00 I want to see Segment Sum of Amount...
Sign up to our newsletter for free automation tips, tricks & discounts