Hi.
Here is my situation, I have 3 worksheets of data. All these worksheets contain different information except for the items I want to use as rows. (which there are three). I need to create one pivot table with all of these sheets, however I don't want a consolidated sheet, because I need to maintain flexibility in manipulating my rows and columns. I'm no good with VBA, plus I need to create something that other (non-excel types) can work with.
Can anyone point me in the right direction?
Audra
Bookmarks