Loading
HomeOther Help › I/S class
Status: Completed
I/S class
Date Posted: 19/02/2021
Category: Other
Due Date: 21/02/2021
Instruction
Create a workbook called [lastname-firstname]Loops.xlsm (don’t forget to save as macro-enabled). Both macros should be assigned to a respective button and should be located on the same worksheet. When you are done, upload your saved workbook below Problem 1: Write a Sub that prints out numbers 1 through 25 in an Excel worksheet using any type of Loop (e.g., Do Until, Do While, For). Problem 2: This one is going to challenge you a bit. But do your best and relax. We will give partial credit for "good attempts". Here is your task: Create a nested-loop program (you can use any type of loop you would like). This nested loop should take the names input (below) and print out every possible combination of first and middle names. These input names will need to appear in your workbook somewhere. (Make sure you type the list of first and middle names in your workbook) Then, output every possible combination of first and middle names somewhere in the worksheet. Your program should work correctly with more or less first names and middle names. Below is an example input and output. To save space, only the names associated with the first two first names are shown in the example output. To explain some more, take 'Penelope' from the first name list and combine it with all middle names in the range and continue till there are no more names in the range of first names. Input First names Middle names Penelope Jill Gwyneth Diane Alice Heidi Anna Lilly Victoria Example Output First names Middle names Penelope Jill Penelope Diane Penelope Heidi Penelope Lilly Penelope Victoria Gwyneth Jill Gwyneth Diane Gwyneth Heidi Gwyneth Lilly Gwyneth Victoria etc. etc.
Attached
No File uploaded yet.
Bidders
paulk 5 years ago
Rated 9.77 earned 9672.34 around 332 assignments.
Hello friend
$30.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}
 
 
Respectwriter 5 years ago
Rated 9.03 earned 26253.25 around 814 assignments.
Hello, I am well conversant with this subject and at a position of delivering the best results on time. Kindly consider my bid and I will not disappoint. I am online ready to work.
$30.00
  • if you have any questions please don't hesitate to ask
    User_27354 | Feb 20, 2021, 04:02 AM
  • Yes I will
    Respectwriter | Feb 20, 2021, 04:02 AM
  • Hello.Are you there
    Respectwriter | Feb 21, 2021, 10:47 AM
  • Yes
    User_27354 | Feb 21, 2021, 12:14 PM
  • Am done with your work and I was wondering if you can add a bonus. It has been quite s hard task to pull through
    Respectwriter | Feb 21, 2021, 12:41 PM
  • Yes, I will add a bonus if you can do both assignments before midnight tonight
    User_27354 | Feb 21, 2021, 12:42 PM
  • Am done actually. How much bonus will u be adding?
    Respectwriter | Feb 21, 2021, 12:43 PM
  • I’ll add 25
    User_27354 | Feb 21, 2021, 13:14 PM
  • Okay. Let me wind up and wil let you know
    Respectwriter | Feb 21, 2021, 13:21 PM
  • Hello, I have uploaded your work and you may now release the payment. Please don't forget to add the bonus as discussed.
    Respectwriter | Feb 21, 2021, 16:24 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}
 
 
kingz 5 years ago
Rated 9.4 earned 52183.12 around 1434 assignments.
Hello kindly assign this to me i can guarantee timely and an A grade work
$45.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}