Summarize a table of data

%3CLINGO-SUB%20id%3D%22lingo-sub-1956690%22%20slang%3D%22en-US%22%3ESummarize%20a%20table%20of%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1956690%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20complete%20table%20with%26nbsp%3B%20a%20large%20number%20of%20options%2C%20brand%2C%20price%20cost%20etc.%3C%2FP%3E%3CP%3EThe%20sales%20people%20go%20down%20this%20list%20and%20populate%20quantities%20purchased.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20this%20information%20to%20summarized%20on%20another%20sheet%20which%20would%20then%20just%20show%20only%20the%20items%20that%20had%20quantities%20placed%20against%20each%20specific%20line.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20this%20be%20done%20using%20pivot%20tables%20or%20does%20it%20require%20a%20macro.%26nbsp%3B%20Anyone%20know%20of%20examples%20I%20could%20copy.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1956690%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1956863%22%20slang%3D%22en-US%22%3ERe%3A%20Summarize%20a%20table%20of%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1956863%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F891348%22%20target%3D%22_blank%22%3E%40MattFalcon%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPivot%20Tables%20pretty%20much%20create%20themselves.%20If%20you've%20never%20used%20one%2C%20play%20around%20with%20it%20on%20your%20own.%20It%20should%20indeed%20do%20what%20you're%20asking.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%20YouTube%20videos%20that%20can%20help%20you%20get%20started%2C%20but%20basically%20you%20highlight%20the%20data%20tables%20(including%20the%20headings)%20and%20click%20on%20Insert....Pivot%20Table%20and%20follow%20the%20prompts.%26nbsp%3B%20You're%20not%20going%20to%20break%20anything%20in%20the%20process%2C%20and%20you'll%20learn%20how.%20Create%20a%20safe%20copy%20of%20your%20data%20if%20you're%20worried%20about%20changes....%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a complete table with  a large number of options, brand, price cost etc.

The sales people go down this list and populate quantities purchased.

 

I would like this information to summarized on another sheet which would then just show only the items that had quantities placed against each specific line.

 

Can this be done using pivot tables or does it require a macro.  Anyone know of examples I could copy.

 

Thanks

1 Reply

@MattFalcon 

 

Pivot Tables pretty much create themselves. If you've never used one, play around with it on your own. It should indeed do what you're asking.

 

There are YouTube videos that can help you get started, but basically you highlight the data tables (including the headings) and click on Insert....Pivot Table and follow the prompts.  You're not going to break anything in the process, and you'll learn how. Create a safe copy of your data if you're worried about changes....