Duplicate Date Sumarize and sum orders by qty parts ordered.

Hello Everyone,

I created a wordbook that tracks all orders, when I click the command button on the Import tab it moves a copy of the data into the summary tab as well as places it into its corresponding tab based on the costumer (Value in Colum A). I would like to create another VBA command button on the import tab that will take the duplicate data, condense it into one line categorized by the summary of each part ordered and move it to the orders tab. I would like the data to be grouped by the qty of each part ordered for each job name for each company. Describing this is difficult so I added an example of the finished product I would like on the Orders tab.

Company name Order Name Order Date Due Date Color Quantity Material Status

Caron Homes Smith 10/1/2014 10/11/2014 White 9 MDF Done
Caron Homes Smith 10/1/2014 10/11/2014 Brown 6 1/4 Inch Active
Caron Homes Smith 10/1/2014 10/11/2014 Antique 3 Melamine Active
^
Sum of the quantity of MDF Parts for Smith Job

I tried making a code using references found in a book I bought about selecting duplicate data. However, this example is only 2 columns and I cant figure out how to match these columns. The purpose of this is to reduce the amount of rows for each job that have duplicate items at different quantities so we can change the status from done to active .

Please Login or Register  to view this content.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Hi Tyler

As you can see, your File has had a lot of looks (17-18?). Probably 6 or 8 of those are mine.

I simply can't figure out what your after. Include in your Workbook a BEFORE and an AFTER Sheet. Describe how/why you got from BEFORE to AFTER.