A table for the data source specific use of a few places is:

The client code breed a month amount
Client code varieties 2 month amount
Client code three varieties in amount

Data source table ZhongKe monthly purchases varieties could be varied more pen for writing a VBA is the variety of statistics last month a variety of total amount and the amount of summary of this month (other varieties only need statistics in the total) the second is the statistics when the annual total amount of the current month only request one and two varieties, and this year all kinds remit total annual remit total

Finally out of basic data format below
This month total this year cumulative
Client code in total amount of two varieties of the breeds variety.


Note: according to customer's code prior to the statistical data sort

CodePudding user response:

Don't need VBA, and dragged out the pivot table directly

CodePudding user response:

reference 1st floor Runnerchin response:

don't need VBA, pivot table can be pulled directly

bad data is mainly the month figure won't be able to use the perspective specific will only take a summary

CodePudding user response:

Data file is best can send to consider pivot table, not achieve the redevelopment,

CodePudding user response:

Don't use the perspective specific will only take a summary

CodePudding user response:

Still want to send data, you can help to see how to make, pivot table is the most convenient option, may be your table didn't design good,