TDazz
12-17-2014, 05:02 PM
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!
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!