Pivot Table question

I am using a pivot table with a single data source. The data source is copied to the page from 2 different sources. When I run the pivot table I make sure all of the data is included as a source, but when I refresh the table, it divides the data into 2 different tables on the same table.

I have found that each table consists of the differnt data sources.

I have tried formatting the complete copied source to text, or having the pivot table count other sources then the name.

I have painted the cells and copied cells. The only thing that has worked was deleting the "bad" cells and starting fresh by retyping all the "bad" data.

Is there another type of formatting that can be done to merge all the data together instead of retyping.

Thanks,

Dopeyfrogg

Define the pivot source with a dynamic named range:
http://www.ozgrid.com/Excel/DynamicRanges.htm

HTH