Need help with VBA script to sort records

[qwertybirdy]

I would really appreciate some help writing a script in the module of the file I have attached.

The "Orders" file contains two worksheets, Orders and Results.

Write a sub to find those customers whose total order amount is greater than $1500 (found in worksheet named "Orders"), and show these customers' IDs and corresponding total order amount in a separate worksheet (show in worksheets named "Results"), and Sort the results by total amount in ascending order.


***Thanks for any help or guidance. I'm pretty lost and I don't know how to approach this code.***

[JieJenn]

Try this see if it works

Please Login or Register  to view this content.