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?