VBA CODE FOR THIS PLEASE!
D 185 Points Powble Requirements Create a subBike"), run by the button, that generates a sentence output like the examples in 13 and 114 for each data batch input. Also, une VIA to calculate the totals and everages in the table to the right of the data. Don't forget to handle the city misselings (without manualy changing the city names in the worksheet in your VBA code. Assume that at least the left three characters are spelled correctly. Also assume there may be more city misspellings elsewhere in the data. Assunte additional data blocis might be added or removed at the bottom, and assume there may be more than one blank row between blocks of data there won't be less than one blank though. Make sure the summary sentences are formatted exactly as shown in the samples (including a period), and appear one after another, rather than next to the block of data. Examples of exactly how the first two summary sentences need to be are shown to the right of where your output should be. Make sure your outputs are placed in the appropriate Highlighted cells. Comment your code so that a grader can follow it. Points may be deducted if there were comments 10 HINT: If you can't finish you will have a better shot at partial credit if you can at least get it to print the first sentence in the appropriate cell. Partial credit will be given for comment code pseudocode) as well 11 12 Surnmary Statistics Table Summary Sentence Summary Sentence Bompies 13 Tot Average Total Lisa solist the Proveeffiefortalo123 14 Name of Gate Location Rating evene sed soldes at the Prove 53.100 15 Location Provo Orem 16. Quantity Provo 17 Revenue $972 Soringate 18 Rating 0 Grand Total 15 Sum 20 Name of Date Red 21 Location plove Make sure to handle this miscapitation 22 Outty 5 in your code without changing the test 23 Merwe $7,160 24 Rating There are three possible minipe edities 25 Prove, Orem, and Springville 26 Name of Date MARE 27 Location Prov They meant Prove here but don't change Save 2 Quantity the spelling. Make your code handle it before 25 Revenge $2,160 30 Rating 1 running! Notice the several blank rowere Use code to account for multiple blank rows 3 Names 35 Location Oren 3. Otity 5 Degrees Calc Total + Bikes Grading Criteria 4 D 185 Points Powble Requirements Create a subBike"), run by the button, that generates a sentence output like the examples in 13 and 114 for each data batch input. Also, une VIA to calculate the totals and everages in the table to the right of the data. Don't forget to handle the city misselings (without manualy changing the city names in the worksheet in your VBA code. Assume that at least the left three characters are spelled correctly. Also assume there may be more city misspellings elsewhere in the data. Assunte additional data blocis might be added or removed at the bottom, and assume there may be more than one blank row between blocks of data there won't be less than one blank though. Make sure the summary sentences are formatted exactly as shown in the samples (including a period), and appear one after another, rather than next to the block of data. Examples of exactly how the first two summary sentences need to be are shown to the right of where your output should be. Make sure your outputs are placed in the appropriate Highlighted cells. Comment your code so that a grader can follow it. Points may be deducted if there were comments 10 HINT: If you can't finish you will have a better shot at partial credit if you can at least get it to print the first sentence in the appropriate cell. Partial credit will be given for comment code pseudocode) as well 11 12 Surnmary Statistics Table Summary Sentence Summary Sentence Bompies 13 Tot Average Total Lisa solist the Proveeffiefortalo123 14 Name of Gate Location Rating evene sed soldes at the Prove 53.100 15 Location Provo Orem 16. Quantity Provo 17 Revenue $972 Soringate 18 Rating 0 Grand Total 15 Sum 20 Name of Date Red 21 Location plove Make sure to handle this miscapitation 22 Outty 5 in your code without changing the test 23 Merwe $7,160 24 Rating There are three possible minipe edities 25 Prove, Orem, and Springville 26 Name of Date MARE 27 Location Prov They meant Prove here but don't change Save 2 Quantity the spelling. Make your code handle it before 25 Revenge $2,160 30 Rating 1 running! Notice the several blank rowere Use code to account for multiple blank rows 3 Names 35 Location Oren 3. Otity 5 Degrees Calc Total + Bikes Grading Criteria 4
