Need help writing VBA code for the following.

CustomerOrders.xlsx looks like the following:

Name your spreadsheet with your network login followed by_a02.xlam. For example, if your network login was barn4520, then your assignment file should be named barn4520 a02.x1sm. 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, S3000), finds the total amount spent by each customer on the list and reports those whose total is more than $3000 (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 value. As part of your sub, sort the list on the Report worksheet in descending order by total amount spent. (Hint: The orders in the Data worksheet are currently sorted by date. It might be helpful to use VBA to sort them by Customer ID. Then 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 workshcct 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 module