buutercup0122
asked on
VBA excel: creating a list from sheet 1 onto sheet 2
The attached file contains account information on customers. I need to write a sub that creates a list on sheet 2 of all the customers who still owe more than $1000. It should first clear the contents of any previous list on sheet 2 and must show customer IDs and the amounts owed and should work even if the amount of data changes.
I am learning excel and would prefer if the solution is simple. Thanks!!
Customer-Accounts.xlsx
I am learning excel and would prefer if the solution is simple. Thanks!!
Customer-Accounts.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you so much, Dave. I really appreciate it. I especially liked that you included your explanations. Also, thank you for the extra explanation of a pivot table! I am truly amazed with your knowledge.
Thanks again,
TC
Thanks again,
TC
ASKER
Perfect. Thank you.
I then Created a Pivot table on those 3 columns, and then created a filter from the Row values Customer ID, on Amount Owed, >= 1000 to generate the same list, using a pivot table.
Cheers,
Dave
Customer-Accounts-r2.xlsm