I need help with Excel VBA question, basic VBA 101. The question with excel data is attached. Please help me. Ex

Excel Data below

Order ID	Segment	Region	Product ID	Category	Sub-Category	Product Name	Quantity	Discount	Sales Amount	Returned
CA-2016-152156	Consumer	South	FUR-BO-10001798	Furniture	Bookcases	Bush Somerset Collection Bookcase	2	0	261.96
CA-2016-152156	Consumer	South	FUR-CH-10000454	Furniture	Chairs	Hon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back	3	0	731.94
CA-2016-138688	Corporate	West	OFF-LA-10000240	Office Supplies	Labels	Self-Adhesive Address Labels for Typewriters by Universal	2	0	14.62
US-2015-108966	Consumer	South	FUR-TA-10000577	Furniture	Tables	Bretford CR4500 Series Slim Rectangular Table	5	0.45	957.58
US-2015-108966	Consumer	South	OFF-ST-10000760	Office Supplies	Storage	Eldon Fold 'N Roll Cart System	2	0.2	22.37
CA-2014-115812	Consumer	West	FUR-FU-10001487	Furniture	Furnishings	Eldon Expressions Wood and Plastic Desk Accessories, Cherry Wood	7	0	48.86
CA-2014-115812	Consumer	West	OFF-AR-10002833	Office Supplies	Art	Newell 322	4	0	7.28
CA-2014-115812	Consumer	West	TEC-PH-10002275	Technology	Phones	Mitel 5320 IP Phone VoIP phone	6	0.2	907.15
CA-2014-115812	Consumer	West	OFF-BI-10003910	Office Supplies	Binders	DXL Angle-View Binders with Locking Rings by Samsill	3	0.2	18.50
CA-2014-115812	Consumer	West	OFF-AP-10002892	Office Supplies	Appliances	Belkin F5C206VTEL 6 Outlet Surge	5	0	114.90
CA-2014-115812	Consumer	West	FUR-TA-10001539	Furniture	Tables	Chromcraft Rectangular Conference Tables	9	0.2	1,706.18
CA-2014-115812	Consumer	West	TEC-PH-10002033	Technology	Phones	Konftel 250 Conference phone - Charcoal black	4	0.2	911.42
CA-2017-114412	Consumer	South	OFF-PA-10002365	Office Supplies	Paper	Xerox 1967	3	0.2	15.55

Scenario An online store runs a survey each year to examine the amount of returns of their orders. The results are in a file called OnlineStoreData.xlsx, available on Blackboard under Assignment/Assignment 3 Each year the company nms a mumber of analyses on the survey. They would like you to write a macro that will automate this. The fields in the dataset include Order ID Segment Region Product ID . Category Sub-Category Product Name Quantity Discount (Measured on a scale of 0.0 (low) to 1.0 (high) Sales Amoumt (Total item price) .Retumed (1 means the order was retumed) The summary statistics presented each year are as follows: Orders Survey Summary Total Number of Orders Total Discount on Product Medium (0.4-0 419 161 36 2.21 402 17 0.34 0.14 3.0 Kept Tatal 2596 5163 243248.55 2.07 0.99 1.66 Home office 0 23 1421 28.3 93 Order ID Ordor Price Minimum Order Price Maximum Order Price CA-2017-124114 CA-2014-145317 23,661 23 NB. The company is looking for a solution that will take into account that the mumber of orders changes from mumbers. You can assume that future sheets will all be organised in the same way. year to year. You need to ensure that your macro will cope with these different order Scenario An online store runs a survey each year to examine the amount of returns of their orders. The results are in a file called OnlineStoreData.xlsx, available on Blackboard under Assignment/Assignment 3 Each year the company nms a mumber of analyses on the survey. They would like you to write a macro that will automate this. The fields in the dataset include Order ID Segment Region Product ID . Category Sub-Category Product Name Quantity Discount (Measured on a scale of 0.0 (low) to 1.0 (high) Sales Amoumt (Total item price) .Retumed (1 means the order was retumed) The summary statistics presented each year are as follows: Orders Survey Summary Total Number of Orders Total Discount on Product Medium (0.4-0 419 161 36 2.21 402 17 0.34 0.14 3.0 Kept Tatal 2596 5163 243248.55 2.07 0.99 1.66 Home office 0 23 1421 28.3 93 Order ID Ordor Price Minimum Order Price Maximum Order Price CA-2017-124114 CA-2014-145317 23,661 23 NB. The company is looking for a solution that will take into account that the mumber of orders changes from mumbers. You can assume that future sheets will all be organised in the same way. year to year. You need to ensure that your macro will cope with these different order