If you're trying to create a pivot table from data on different sheet,
there's information he

http://www.contextures.com/xlPivot08.html

If you're trying to do something else, you could provide some details,
and someone may be able to help.

Userx wrote:

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html