Pre-Formatted Pivot Table

dmill8023

Board Regular
Joined
Aug 24, 2012
Messages
60
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?
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,556
Messages
5,637,027
Members
416,954
Latest member
Gohar hussain

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top