I have a file that has 2 parts to it. In the first sheet it has a list of item quantity break codes with the different breaks each code has. Each break corresponds to a different price but that isn't relevant here. The second sheet has a list of data that includes item number, break code, year, qty, and sales.
I am trying to find a way break the data down by year so that 2013 is next to 2014 and so on. Within each year each item number would have the number of orders counted and sales summed based on the items qty that occurred in each order and matched into the quantity break table.
I don't know how to upload a file here but I included a link to another site where I created a thread there and was able to upload the example file.
Can a macro sum multiple things to multiple criteria?
Not sure if a macro or pivot table could do this because there are 190 different qty break codes that each have their own unique set of 7 breaks so it seems to complicated for a pivot table.
Please Help!!!
I am trying to find a way break the data down by year so that 2013 is next to 2014 and so on. Within each year each item number would have the number of orders counted and sales summed based on the items qty that occurred in each order and matched into the quantity break table.
I don't know how to upload a file here but I included a link to another site where I created a thread there and was able to upload the example file.
Can a macro sum multiple things to multiple criteria?
Not sure if a macro or pivot table could do this because there are 190 different qty break codes that each have their own unique set of 7 breaks so it seems to complicated for a pivot table.
Please Help!!!
