Question: T I need a VBA code! Im having trouble. Microsoft Office Home -Assignments-Intro to Info p. D G Chegg Study | Guided Solutio/X | G

T I need a VBA code! Im having trouble. Microsoft Office T Home -Assignments-Intro to Info p. D G Chegg Study | Guided Solutio/X

I need a VBA code! Im having trouble.

Microsoft Office Home -Assignments-Intro to Info p. D G Chegg Study | Guided Solutio/X | G want to insert data at bottom X X vBA,03 x C https://s3.useast-1.amazonaws.com/blackboar d learn.xythos prod/598bd1 1974856 3997234?response content-dispositionsinline%3B%20filer ame%2A%3DUTF-8%27%27H. App Foreign look > Mexi SIUE Emailmy8lackboardCougarNET Student Employment 2. Redo the YTD sales exercise; however, show the total at the bottom of each sales rep's column (right below $768, $193. $501, $187) Use For Next to find the last row for each column and put a formula below the row 3. Continue the YTD sales macro as follows: Ask a specific salesperson's name using an InputBox Find the person and put his/her average sales at the bottom of the column. Show the average in bold. OType here to search 9/19/2018 7

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!

can someone please help me!!! i keep getting stuck at step 5 Exp19_Excel_Ch12_Cap_Bulldog_Collectibles Project Description: You are the operations manager for Bulldog collectables, a small start-up...

Exam 3-Scaling Up with VBA Learning Objective: In this assignment, you will use your recently acquired knowledge of Excel VBA coding to scale up the analysis from the previous exercise. You should be...

No looping/iterations please. Create a new Excel Workbook named yourlastName P3.xlsm (replacing yourlastName with-your last namel) and write the VBA code to estimate employee P3.xism( payroll...

So I can make the flowchart but not sure how to make the VBA code. It's all super foreign to me 13.5 VBA Project: Olympus Tours You have just been hired by Olympus Tours (OT), a bus rental company...

- Code Implementation: - Implement all required functionalities using VBA functions, loops, and user input handling. - Organize the code and include comments explaining the FIFO calculation steps...

Need to put this formulas into VBA and create this in excel. i need to put this formulas into VBA and then answer the questions. PSTDEV Probability 10% 20% 40% 20% 10% Value -30.00% PStdevo) =...

Could someone please answer this, with steps and pictures ? Thank you Grader - Instructions Excel 2019 Project Grader - Instructions Excel 2019 Project Step Instructions Points Possible 10 12...

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 =...

Write a VBA Excel DO LOOP. Loan Amortization Schedule Use the format shown below to construct two different loan amortization schedules. One solution will be a spreadsheet only solution, labeled...

The core idea(s) of sustainable development is (are): Economic development must be accomplished sustainably, Poverty is an underlying cause of environmental degradation. Affluence is an underlying...

Assume the same facts as in P8-11, except that the FMVs for the inventory and fixed assets of Rachel are not as precisely specified. That is, appraisers have indicated that the FMV of the inventory...

Cooper is a 2 2 - year - old college student. According to Dietary Guidelines for Americans 2 0 2 0 - 2 0 2 5 , saturated fat should comprise q , of his total energy intake each day. 4 5 to 5 5 %...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

6. How might the team seek additional information from the community?

4. Who would lead the group?

Were the team members dependable? If not, how were they held accountable?