Hi

Is there an easy way to consolidate multiple sheets into one pivot table in excel when text is being used rather than numbers?

I want the behaviour to work in such a way such that when say sheet 2 has something in a cell that sheet 1 as already filled then sheet one should take priority over sheet 2's value.

can this be done easily?

thanks

Howdy. Here is a tutorial and example on how to do that: Contextures on Pivottables (http://www.contextures.com/excelfiles.html#Pivot), using MS Query.

And from the Horse's mouth (http://support.microsoft.com/?kbid=213947), er... Microsoft, without using MS Query.