Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Need help writing VBA code for the following: That is how CustomerOrder.xlsx looks like The file CustomerOrders.xlsx shows orders by date for a company's customers
Need help writing VBA code for the following:
That is how CustomerOrder.xlsx looks like
The file CustomerOrders.xlsx shows orders by date for a company's customers on the Data worksheet. Many customers have ordered more than once, so they have multiple entries in the list. Write a sub that asks the user for a total (for example, 53000). finds the total amount spent by each customer on the list and reports those whose total is more than S3000 (the amount provided by the user) on a new worksheet called Report. Have the program ask the user for a total until the user enters a valid valuc Customer IDThen at the end of the sub, restore the list to its original condition by sorting on Date.) Make sure your code checks to see if the Report workshect exists before it does any new calculations. Any previous existing Report worksheet should be deleted before a new one is created. Create your Results worksheet so it looks something like this before your data gets filled in: 1 Customers who spent more than $3000 3 Customer ID Total amount spent Notes and Tips: Be sure to include basic data validation/error checking to avoid data type mismatches and other errors. Have the program ask the user for a total until the user enters a valid value. Make a button on the Data worksheet to run your subroutine. Save the file with the data and your code as a2_username xlsm where username is your network login Ensure your name and current date are at the top of each code moduleStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started