Excel VBA help! Duplicate orders with same customer ID totals?

[TDazz]

Hi I am new to writing VBA and would appreciate any help!

I have a workbook with two worksheets. The "Orders" worksheet contains three columns order date A4:A548, customer ID B4:B548 and order amount C4:C548.

Since customers ordered more than once, there are multiple entries of the same customer IDs. I was hoping to find the customers whose total order amount is more than $1000 and then show those customers' IDs and their corresponding total order amount in the second worksheet "Coupon".

If it would help I can try to attach the workbook. Thank you for your consideration!

[Blade Hunter]

If this is a one off I would just copy the customer column and paste it somewhere else a few columns over, then click the data tab and click remove duplicates then hit OK. Then use a sumif formula to get the totals per customer.

Cheers

Dan

[SamT]

You have to make at least three posts before you can attach files.

Then use the Go Advanced button and look below the advanced editor.