copy updated table values to a "summary" worksheet

[goodfish]

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.

 

[ryguy7272]

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---