Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the workbook SalesData.xlsm. Create a module that will do the following: Use an input box to input a number between 10,000 and 12,000. Check

Use the workbook SalesData.xlsm. Create a module that will do the following: Use an input box to input a number between 10,000 and 12,000.

Check to see for sure that the number input is between 10,000 and 12,000. If it is not, have the user re-enter the number. (A Do While loop will work) Use the number obtained from the input box and use nested For ...

Next loops and if statements to find all cells in the worksheet that exceed that number. Offsets and .end(xldown).rows.count might be helpful or use a For each loop Use a constant for the number of months For those numbers that exceed the given # Use code to make the font of the number in the cell bold. Use code to make the font of the number in the cell red. Make sure that your method will allow you to include all cells no matter how many rows and columns are added or deleted. Write a 2nd procedure (in the same module) to restore the sheet back to original state (clear contents) Add 2 buttons on the sheet: 1 to run, 1 to restore Document your work in the code.

The sales data is given below.

image text in transcribed

A B D E F G H 1 J j K L M N 0 P Q May Aug 14055 14472 19472 14304 14087 10 9329 we 9007 wer 9244 4** 8532 0334 11043 1 2 Region 1 3 Region 2 4 Region 3 5 Region 4 6 Region 5 7 Region 6 8 Region 7 9 Region 8 10 Region 9 11 Region 10 12 Region 11 13 Region 12 14 Region 13 15 Region 14 16 Region 15 17 Region 16 18 Region 17 19 Region 18 20 Region 10 20 Region 19 21 Region 20 22 Region 21 23 Region 22 24 Region 23 25 Region 24 26 Region 25 27 Region 26 27 Region 26 28 Region 27 29 Region 28 30 Region 29 31 Region 30 32 Region 31 33 Region 32 34 Region 33 35 Region 34 36 Region 35 37 Region 36 38 Reaion 37 Dec 9445 13913 *** 6824 way 14945 *** 1199 11194 10431 14306 17300 13436 9875 9934 *** 7101 110 8087 10362 10362 8382 11656 Jan 13531 14399 9118 110 5680 wood 8511 w 11438 *** 5089 wo 13322 3324 9324 6485 wo 8712 0714 11725 11725 14101 1910 12234 12234 6424 92 11916 12222 12222 12630 1092 10930 8722 5788 12578 13578 10342 10016 9306 10849 13255 13022 11410 6609 8489 02 7447 9140 149 7807 8629 9608 6675 Feb 7014 8438 14837 14382 ***04 7202 14922 19224 8035 003 10581 1058 5997 8434 wer 5087 8227 DEL 9371 13536 14854 11230 8427 8437 enos 005 8083 9680 11606 2102 8192 200E 7965 1250 12582 6207 6307 Mar 5678 11724 6229 wa 8143 wake 12166 ** 8586 wy 10394 10594 14055 1405 8536 10843 10045 W0u 9580 14551 1933 9974 10785 11627 11627 13903 13466 10381 11150 11159 12717 12747 10351 6297 6297 122 12354 2710 8748 Apr 13589 14419 6826 12194 ** 14547 1934 9590 20 1221 12279 01.10 8118 14864 17004 13809 1300 10023 10020 10941 8310 8310 1037 14097 6406 10275 13237 13143 9104 8622 8622 10506 10506 1485 14850 FEED 5558 SOM 5944 6789 9581 12091 12344 14572 5029 8855 10196 2012 5490 9 13829 8637 9813 5687 5357 7854 10611 wa 13596 12145 *** 14748 14770 13571 1337 5156 14892 9517 ar 13184 9166 11616 9013 5920 5920 way 12882 12882 6870 0070 11680 12177 12177 12068 12068 12646 600 6040 8737 7026 10989 8441 9481 7452 13445 12149 *** 7373 wer 11922 *2224 9904 7871 10819 11016 5345 Jun 8169 5005 8652 9343 125 120 12095 8338 30 13288 13200 10260 10200 13231 1223 13902 13962 7467 101 10904 10904 14094 13585 13635 13635 0079 8879 11955 7930 12418 12418 9321 6584 10949 6610 6618 13039 10877 10601 9735 14219 ** 6600 wa 1933 13334 13974 14277 1. 9914 2 9770 11523 13202 8435 Jul 8907 7679 1019 6725 13795 10812 2012 12141 6021 04 14481 6601 OUT 12928 11559 119 12369 11999 11999 6092 0092 5980 wou 6058 0050 9473 11795 9918 9918 11350 13702 9339 FAE 5045 12108 12508 12654 5775 11494 13143 11339 5466 14552 8181 20 12219 6730 12119 10842 10607 1000? 5650 12897 9877 20 9401 8475 13853 14582 12699 10555 719) 7182 9667 9667 14645 14645 6100 6490 1223 12322 Sep 5751 11185 12708 am 9826 9375 wa 11647 11047 7508 1508 Dor 6871 5209 3209 10149 10149 10163 10163 9152 13700 13700 12778 7053 14627 14637 7667 7667 6242 6347 10359 11096 11578 11025 11946 2009 7903 142 11267 12295 12225 13106 5364 8576 wer 6544 12126 cy 10004 13081 20 7775 11935 13790 10483 12426 Oct 5254 7053 8687 14107 20 11046 11040 5647 304 9103 5282 12439 12439 11697 5349 3349 12908 12900 10845 10259 8021 6327 6327 W2 10844 7279 14010 14040 12986 ELE 5154 7942 7943 8546 5101 12288 12388 11420 12635 5308 ce 10489 19329 14528 11261 *120 5925 22 12255 *** 5915 9633 6314 9992 Nov 13383 13263 10696 12550 *** 9954 22 0214 8972 5938 8692 0034 12237 1223 10194 *0127 8428 0420 8830 14601 14001 11825 7691 103 14499 14499 14414 10179 12024 12024 9163 7128 8622 8623 10475 13896 12351 6744 9356 9504 9484 8359 11451 *** 12113 *** 7324 8487 11090 11726 14593 13890 12848 11957 12150 9851 9651 10633 7948 12090 5631 ww 6186 12704 5682 we 6709 6289 10103 10997 12171 12195 8232 9856 5406 8781 11292 11393 11270 11278 5427 11540 11518 13019 8551 8825 8435 8217 13257 6059 8649 8696 8524 8599 14547 14752 12879 6620 w 6134 14997 12481 1470" 9049 2012 7454 8588 8539 11092 12561 13387 wer 5637 6580 wy 6568 wo 6201 wa 6481 10512 10701 6518 6473 Data + A B D E F G H 1 J j K L M N 0 P Q May Aug 14055 14472 19472 14304 14087 10 9329 we 9007 wer 9244 4** 8532 0334 11043 1 2 Region 1 3 Region 2 4 Region 3 5 Region 4 6 Region 5 7 Region 6 8 Region 7 9 Region 8 10 Region 9 11 Region 10 12 Region 11 13 Region 12 14 Region 13 15 Region 14 16 Region 15 17 Region 16 18 Region 17 19 Region 18 20 Region 10 20 Region 19 21 Region 20 22 Region 21 23 Region 22 24 Region 23 25 Region 24 26 Region 25 27 Region 26 27 Region 26 28 Region 27 29 Region 28 30 Region 29 31 Region 30 32 Region 31 33 Region 32 34 Region 33 35 Region 34 36 Region 35 37 Region 36 38 Reaion 37 Dec 9445 13913 *** 6824 way 14945 *** 1199 11194 10431 14306 17300 13436 9875 9934 *** 7101 110 8087 10362 10362 8382 11656 Jan 13531 14399 9118 110 5680 wood 8511 w 11438 *** 5089 wo 13322 3324 9324 6485 wo 8712 0714 11725 11725 14101 1910 12234 12234 6424 92 11916 12222 12222 12630 1092 10930 8722 5788 12578 13578 10342 10016 9306 10849 13255 13022 11410 6609 8489 02 7447 9140 149 7807 8629 9608 6675 Feb 7014 8438 14837 14382 ***04 7202 14922 19224 8035 003 10581 1058 5997 8434 wer 5087 8227 DEL 9371 13536 14854 11230 8427 8437 enos 005 8083 9680 11606 2102 8192 200E 7965 1250 12582 6207 6307 Mar 5678 11724 6229 wa 8143 wake 12166 ** 8586 wy 10394 10594 14055 1405 8536 10843 10045 W0u 9580 14551 1933 9974 10785 11627 11627 13903 13466 10381 11150 11159 12717 12747 10351 6297 6297 122 12354 2710 8748 Apr 13589 14419 6826 12194 ** 14547 1934 9590 20 1221 12279 01.10 8118 14864 17004 13809 1300 10023 10020 10941 8310 8310 1037 14097 6406 10275 13237 13143 9104 8622 8622 10506 10506 1485 14850 FEED 5558 SOM 5944 6789 9581 12091 12344 14572 5029 8855 10196 2012 5490 9 13829 8637 9813 5687 5357 7854 10611 wa 13596 12145 *** 14748 14770 13571 1337 5156 14892 9517 ar 13184 9166 11616 9013 5920 5920 way 12882 12882 6870 0070 11680 12177 12177 12068 12068 12646 600 6040 8737 7026 10989 8441 9481 7452 13445 12149 *** 7373 wer 11922 *2224 9904 7871 10819 11016 5345 Jun 8169 5005 8652 9343 125 120 12095 8338 30 13288 13200 10260 10200 13231 1223 13902 13962 7467 101 10904 10904 14094 13585 13635 13635 0079 8879 11955 7930 12418 12418 9321 6584 10949 6610 6618 13039 10877 10601 9735 14219 ** 6600 wa 1933 13334 13974 14277 1. 9914 2 9770 11523 13202 8435 Jul 8907 7679 1019 6725 13795 10812 2012 12141 6021 04 14481 6601 OUT 12928 11559 119 12369 11999 11999 6092 0092 5980 wou 6058 0050 9473 11795 9918 9918 11350 13702 9339 FAE 5045 12108 12508 12654 5775 11494 13143 11339 5466 14552 8181 20 12219 6730 12119 10842 10607 1000? 5650 12897 9877 20 9401 8475 13853 14582 12699 10555 719) 7182 9667 9667 14645 14645 6100 6490 1223 12322 Sep 5751 11185 12708 am 9826 9375 wa 11647 11047 7508 1508 Dor 6871 5209 3209 10149 10149 10163 10163 9152 13700 13700 12778 7053 14627 14637 7667 7667 6242 6347 10359 11096 11578 11025 11946 2009 7903 142 11267 12295 12225 13106 5364 8576 wer 6544 12126 cy 10004 13081 20 7775 11935 13790 10483 12426 Oct 5254 7053 8687 14107 20 11046 11040 5647 304 9103 5282 12439 12439 11697 5349 3349 12908 12900 10845 10259 8021 6327 6327 W2 10844 7279 14010 14040 12986 ELE 5154 7942 7943 8546 5101 12288 12388 11420 12635 5308 ce 10489 19329 14528 11261 *120 5925 22 12255 *** 5915 9633 6314 9992 Nov 13383 13263 10696 12550 *** 9954 22 0214 8972 5938 8692 0034 12237 1223 10194 *0127 8428 0420 8830 14601 14001 11825 7691 103 14499 14499 14414 10179 12024 12024 9163 7128 8622 8623 10475 13896 12351 6744 9356 9504 9484 8359 11451 *** 12113 *** 7324 8487 11090 11726 14593 13890 12848 11957 12150 9851 9651 10633 7948 12090 5631 ww 6186 12704 5682 we 6709 6289 10103 10997 12171 12195 8232 9856 5406 8781 11292 11393 11270 11278 5427 11540 11518 13019 8551 8825 8435 8217 13257 6059 8649 8696 8524 8599 14547 14752 12879 6620 w 6134 14997 12481 1470" 9049 2012 7454 8588 8539 11092 12561 13387 wer 5637 6580 wy 6568 wo 6201 wa 6481 10512 10701 6518 6473 Data +

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

Which months of this year 5 Mondays ?

Answered: 1 week ago

Question

Define Leap year?

Answered: 1 week ago

Question

Prepare a short profile of Lucy Clifford ?

Answered: 1 week ago

Question

Prepare a short profile of Rosa parks?

Answered: 1 week ago

Question

Evaluate the importance of the employee handbook.

Answered: 1 week ago

Question

Discuss the steps in the progressive discipline approach.

Answered: 1 week ago