Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1374
  • Last Modified:

Powershell with Excel Pivot Table

Ok. Attaching what I have already. I would like powershell take the table in attachment 1, which is its own worksheet named "AllServers" , create a new sheet name with a pivot table from attachment 2. Is this even possible?

Attachment 1
Attachment1
Attachment 2
Attachment 2
0
Xytras1
Asked:
Xytras1
1 Solution
 
David Johnson, CD, MVPOwnerCommented:
powershell knows nothing about pivot tables and an excel vba solution would be a much better fit.
0
 
Xytras1Author Commented:
Thanks for the Info.
0

Featured Post

Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now