Macro to Automate Report by Case Number and Product Type (Macro Recorder Fail)

Hello I have a question very similar to the case located in forum.


http://www.excelforum.com/excel-prog...68#post2820568

Original Raw Data Set Consists of 3 different case numbers followed by a unique number; each case number also has an associated product type
Case Numbers are ZW, ZR and ZC // Product types are 114455, 114466, 995566, 995577

I am looking for macro to automate sorting of raw data, insert rows, calculate sum by both case number and product type.

I have created macro to perform this function (utilizing the macro recorder) however the macro is not static and will only work on the raw data set that it was coded with. Since there are constant changes in the original data set, I need the macro to recognize the difference between a ZW and ZR (rather than hard coded at line 107)

I have created and attached a sample work book with the original data set and the desired resultsRawDatatoReport.xlsx

Any answers out there?

Hi

Here's one

Please Login or Register  to view this content.

rylo

try

Please Login or Register  to view this content.

Wow thanks these both work beautifully.

you are my hero