Hello,
I am new to this forum and would be very grateful to any help i can get.
I am trying to create a VBA Macro that outputs a summary based on a number of variables. The variables would be Client, Product, Month and Year.
Currently i have managed to write a code which searches for these variables and gives me each unique record found that matches the criteria.
My issue is, i would like to have my code output the sum of values for each unique Product (variable) which i assume can be done by creating and array and adding the values whenever the same product is found in my data. The unique products exceed 700 in number and each client would be using different products.
I have attached a sample of the spreadsheet i am using with the current code that will produce only unique records and not sum by product. My actual spreadsheet contains data that exceed 10,000 rows and the products in question are over 700 unique records.
Thank you in advance for any help. In the meantime i will still be searching for similar examples or solutions.
Bookmarks