cesarmontoya
New Member
- Joined
- Aug 2, 2013
- Messages
- 3
I get excel reports generated from an outside source/software.
It comes sliced in a few ways, and there are several worksheets named Inventory Summary, Inventory Summary2, etc.
I need a macro so I can run it, and get the raw data from it, ALL OF IT.
I know that I can go into the PivotTable field list, and SELECT everything, then double click a grand total, and I will get the raw data, not only this takes time (I have over 150k rows, and 30 columns) but I just don't feel comfortable doing it.
Any ideas on a macro?
Thank you!
It comes sliced in a few ways, and there are several worksheets named Inventory Summary, Inventory Summary2, etc.
I need a macro so I can run it, and get the raw data from it, ALL OF IT.
I know that I can go into the PivotTable field list, and SELECT everything, then double click a grand total, and I will get the raw data, not only this takes time (I have over 150k rows, and 30 columns) but I just don't feel comfortable doing it.
Any ideas on a macro?
Thank you!
