Search found 1 match
- 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...