There is a tab data in excel of departments, regions, products, customers, and purchases for the month. I have set up a pivot table in a tab for this data and would like a VBA macro or code that organizes/filters the pivot table by the department, shows the names of customers in the rows, and for the sum of values show the sum of the current month purchases by each customer.
Then, I’d like to have the macro generate a list of customers with sales over 20k, 10-20k, less than 10k in the following format to generate in an excel cell:
● >20K: Customer A +Ak, Customer B +Bk, Customer C +Ck
● 10-20K: Customer D +Dk, Customer E +Ek
● <10K: X Customers
For less than 10k, the customers don’t need to be listed out, the number of customers with purchases between 0 to 10k should be counted for the generation of information. Thanks.