Hi,

(Sorry for Xposting. I already posted this in the MS/XL/Misc NG but
received no replies.
Everybody there must still be on vacation ... ?
I really would like to do this *without* programming but I know that this is
where the gurus hang out. :)

I have a large CSV data file that I am using as an "external data source"
for a Pivot table in an (autoupdate) template.
That works fine. It's the sales file created automatically by an
application. So it's "sales.csv" and my template with the Pivot table is
"sales.xlt".

But I also have costs, so I have another file where costs are recorded
manually. The data is in "Costs.xls" and I will have another Pivot table
where I analyse the costs : "Costs.xlt"

Now I want to offset Costs against Sales, so I am looking for some way to
get a new pivot table to read both the Sales.CSV and the Costs.XLS data and
combine the data and display the results.

Anyone here know how to do that ?
Or, can anyone point me to a howto site where that is explained.


TIA

Erasmus