>Although I can produce a VFP Report to show summaries by Suppliers, I do not know how to produce the same thing in an EXCEL file. Is this difficult?
>
>I have 5 fields only:
>Internal_Company_Name
>Supplier
>Item
>Item_Desc
>Annual_Purchase_Amount (Per item)

What do you mean Cecil? Do you mean exporting the VFP report to Excel?

In the first case I have developed an Excel Listener class that is working fairly well by now. I can send you the latest version if it helps.

If you perform a filter operation on an Excel column the total row will only sum the rows that are part of the filter, but you can only see one filter value at a time.

Alex