I have a different excel file for each customer. In each file I have a series
of "tables" representing individual contracts, within which I store
merchandise specs and which I update manually as invoices are paid, with
"invoice name", "commision amount" and "date of payment".
I have recorded a little macro that filters these last datas (after I update
the customer file) onto a new worksheet....
Now I would like for each customer to be able to take the filtered data
(updated) and show it together on a summary file. (grouped by customer name)
I am sure it is not so impossible but I have lost a lot of time trying
different things and I cannot see a way.

I think this will do what you want:
http://www.rondebruin.nl/copy2.htm

It may behoove you to look at this too:
http://www.rondebruin.nl/copy5.htm


HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"goodfish" wrote:

> I have a different excel file for each customer. In each file I have a series
> of "tables" representing individual contracts, within which I store
> merchandise specs and which I update manually as invoices are paid, with
> "invoice name", "commision amount" and "date of payment".
> I have recorded a little macro that filters these last datas (after I update
> the customer file) onto a new worksheet....
> Now I would like for each customer to be able to take the filtered data
> (updated) and show it together on a summary file. (grouped by customer name)
> I am sure it is not so impossible but I have lost a lot of time trying
> different things and I cannot see a way.
>