Help moving values based on cell values from one sheet to another

[RGPRICE]

Hi there,

I’m trying to figure out the macro needed to move and compile information from one sheet to another based on vendor names. The first sheet has shipment listings, name of supplier, contents, etc. and is constantly being added to. I’m trying to make a macro that will take that information and compile it in another sheet with each vendor only taking up one row.

So if it were like

Vendor|Product Amount|Defect Amount|Etc
VendorA|300|12|
VendorB|17|0|
VendorA|200|0|

The second sheet would read

VendorA|500|12|
VendorB|17|0|


I don’t know if I explained it well but that’s what I’m trying to do

 

[Cubist]

Have you tried Pivot Table?

 

[RGPRICE]

Have you tried Pivot Table?

I have not, mostly because I’m not sure what that is

 

[Cubist]

Select your data with headers -> Insert -> Pivot Table -> Select a location -> Drag Vendor into the Rows then Product Amount and Defect Amount into Values

Book1
	A	B	C	D	E	F	G	H
1	Vendor	Product Amount	Defect Amount			Row Labels	Sum of Product Amount	Sum of Defect Amount
2	Vendor A	300	12			Vendor A	500	12
3	Vendor B	17	0			Vendor B	17	0
4	Vendor A	200	0			Grand Total	517	12
Sheet1

 

[RGPRICE]

Select your data with headers -> Insert -> Pivot Table -> Select a location -> Drag Vendor into the Rows then Product Amount and Defect Amount into Values

Book1
	A	B	C	D	E	F	G	H
1	Vendor	Product Amount	Defect Amount			Row Labels	Sum of Product Amount	Sum of Defect Amount
2	Vendor A	300	12			Vendor A	500	12
3	Vendor B	17	0			Vendor B	17	0
4	Vendor A	200	0			Grand Total	517	12
Sheet1

This looks perfect, thank you

 

[Cubist]

You're welcome.