"Tami" wrote:

can you pivot across several tabs?

i have a work sheet where the buyer plans a class 111 on tab 1, class 123 on
tab2....and my buyers are very good at pivots but we can't figure out how to
pivot across different worksheets.

Pivot table with Multiple Consolidation Ranges
ALT Data, Pivot to bring up the wizard

It did create a pivot table with data from 5 different tabs;

Mike