Pivot Tables comming from two data sources

I have two tabs in a workbook. One contains the daily results of marketing campaigns the other contains all the campaign information.

I want to create a thrid tab that combines the two sets on data into one report. I want this to be driven by entering a code (order source code) in one cell.

So far all I can do is enter the source code twice to drive two seperate pivot tables. How can I just get one table with all the data?

Thanks in advance for any sugestions.

RBW

Thanks - sounds like it will work I'll try it first thing next week.