Link to home
Start Free TrialLog in
Avatar of buutercup0122
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
ASKER CERTIFIED SOLUTION
Avatar of dlmille
dlmille
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
FYi - and for fun.  Here's the same workbook, where I added an additional Column to your source data, called Amount Owed.

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
Avatar of buutercup0122
buutercup0122

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
Perfect. Thank you.