I need to generate reports regularly from a database that is routinely updated. I have tried using pivot tables to extract the data that I want to report or graph. I have become frustrated with pivot tables either due to my lack of experience or limitations in the tables. I am looking for a non-pivot table method of generating the same reports. IN this database I have a list of exporters that can change from month to month. How can I generate a unique list of these exporters from the database?
For Example
Exporter Month Volume
X Jan 20
Y Jan 15
X Feb 10
Z Feb 30
A Mar 5
How do I automatically generate a list that would contain A, X, Y, and Z? I would use this list and sumproducts/vlookups to generate the reports that the pivot tables used to generate?
Thanks
For Example
Exporter Month Volume
X Jan 20
Y Jan 15
X Feb 10
Z Feb 30
A Mar 5
How do I automatically generate a list that would contain A, X, Y, and Z? I would use this list and sumproducts/vlookups to generate the reports that the pivot tables used to generate?
Thanks