Question: Write a sub using VBA in Excel: Lets read the sales reps and amount from the Ohio Sales sheet and save them in parallel arrays

Write a sub using VBA in Excel:

Lets read the sales reps and amount from the Ohio Sales sheet and save them in parallel arrays Lets use dynamically sized arrays Then, lets look in the array for sales rep for Cochran and report the total sales for CochranIf we find it, report the total sales amount in a message box If we dont find it, report the fact that this Sales Rep had no sales in Ohio

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Read Chapters 1,2,4,7 and Write a 800 - 1000 word Reflection Paper Grading : ?Thoughtfulness?Reactions,personal experiences,criticisms, etc. ?Application to your futureprofessional(and personal)life...

Write a sub using VBA in Excel (in a MODULE ) called HW10_Num1 that will determine if your Project 1 assignment earns you a token, costs a token or has no impact, using one or more if statements....

Write a sub using VBA in Excel (in a MODULE) that will print, in a message box, six rows of numbers. Row i will have 3 numbers: i , 2* i and 3* i . Use a for loop for this problem.

For Questions 1 and 2, manually enter the word Score into cell A1, and manually enter 68 into cell B1. Write a sub that uses the If Construct. If the value in cell B1 is greater than 75, cell B1...

Do question 3 in excel please. below is the sheet to base it off of. For Questions 1 and 2, manually enter the word Score into cell A1, and manually enter 68 into cell B1. 1. (5 points) Write a sub...

VBA CODE Data needed to do the problems is on this link https://www.contextures.com/xlSampleData01.html Write a code using VBA that: ' Create a UserForm with a single-select ListBox. Initialize it...

3. (8 points) Starting with the Sales Data file, write a sub using a For Each loop that counts the number of sales during the year that are greater than 10,000 but smaller than 12,000. Display the...

6. The file Training.xlsx contains the data set of five training exam scores for employees. The manager wants to find out which exam has the best performance (the one with the highest average score...

in excel using developer 1. (4 points) Open a workbook, get into the VBE, insert a module, and enter the following code: Public Sub NowYouSeeMe0 Dim myName as String, nMiles as Integer yourName =...

H A B D 1 OrderDate Region Rep Item 2 1/6/10 Northeas Jones Pencil 3 1/23/10 South Kivell Binder 4 2/9/10 South Jardine Pencil 5 2/26/10 South Gill Pen 6 3/15/10 West Sorvino Pencil 7 4/1/10 Northeas...

Create an organizational chart to represent the ideal structure for your current organization (or one with which you are familiar). You should include: the type of structure (divisional structure,...

1 Margue is a self-employed accountant who earns about $60,000 annually. She is reviewing her financial situation and worried about what would happen if she was unable to work through no fault of her...

1. Discuss the optimal method for procuring inputs that have well-defined and measurable quality specifications and require highly specialized investments. What are the primary advantages and...

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

3. What should a contract of employment contain?

1. What does the term employment relationship mean?

understand and describe the rights and obligations of the employer and employee to the employment relationship