Hello all-- Wondering if there is a way to pre-format a pivot table for an analysis template I'm working on. I have a data template tab titled Raw Data and in column M is my Origin State to track a shipment. The range that I'm working with is M3:M20002. The goal I am looking for is to be able to Copy and Paste data from an external spreadsheet into my template, once my Origin State is entered in Column M I want a "pre-formatted" pivot table to be able to capture the count of unique states. By saying pre-formatted I mean that I have a unpopulated pivot table that is pre-formatted to read range M3:M20002. Is this possible? If not suggestions?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Pre-Formatted Pivot Table
- Thread starter dmill8023
- Start date
Jerry Sullivan
MrExcel MVP
- Joined
- Mar 18, 2010
- Messages
- 8,787
Hi dmill8023, You can't have an unpopulated PivotTable however you can make a pre-formatted PivotTable template that has a header row and 1 row of example data.
Using that you can paste in your actual data (overwriting the row of example data), then refresh your PivotTable.
Using that you can paste in your actual data (overwriting the row of example data), then refresh your PivotTable.
Upvote
0
