Need Marco to Combine and Sub Total data

[Gbadd]

I am working with a large amount of data that needs to be combined by RA# and then sub totaled by material number.

RA #	Store #	Material	Customer Material	Order qty	UoM	Return Plant	Box Plant	Production plant
60178173	7247	38125ESS	14746640086	1	EA	V796	D796	PCON
60178173	7247	38125ESS	14746640086	1	EA	V796	D796	PCON
60178173	7247	38125ESS	14746640086	1	EA	V796	D796	PCON
60178173	7247	05846AQU	14746558466	1	EA	V796	D796	PCON
60178173	7247	05846AQU	14746558466	1	EA	V796	D796	PCON
60171864	7247	26342BIO	17541621557	1	EA	V796	D796	PCON
60171864	7247	26342BIO	17541621557	1	EA	V796	D796	PCON
60171864	7247	26342BIO	17541621557	1	EA	V796	D796	PCON

<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

After the macro is run the result should match the table below.

Store	Material	Order qty	UoM	RA #
7247	38125ESS	3	EA	60178173
7247	05846AQU	2	EA	60178173
7247	26342BIO	3	EA	60171864

<colgroup><col><col><col><col span="2"></colgroup><tbody>
</tbody>

 

[engineer69]

Try the SUMPRODUCT function. It's basically a nested look-up based on multiple criteria.

 

[Gbadd]

Try the SUMPRODUCT function. It's basically a nested look-up based on multiple criteria.

Thank you for your response. I do not think SUMPRODUCT would work for me. We get raw data from the warehouse of all the materials a store returned us. We have over 900 different materials that can be returned to us and we are using a data collection scanner out in the warehouse to record what is coming in. Basically what happens is the customer has a RA # and when they receive it they can send the material(s) back to us to get credit. Once it arrives a warehouse man takes the RA paperwork off the pallet and enters the RA # and Store number into the scanner and then they scan the UPC code on the product. Some of these returns may have twenty different materials with fifteen or more of each material. At the end of the day the warehousemen dump the data into into an Excel file. Basically I end up with this large Excel file that has around 5 to 10 thousand lines on it and I need to quickly have Excel tell me the total of each material grouped by the RA number and store number.