Create a Macro using the Macro recorder and Visual Basic statements that will do the following:...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Create a Macro using the Macro recorder and Visual Basic statements that will do the following: 1. Create a macro recording the advanced Filter for just those employees located in Chicago Create a form button for this macro and call it Chicago assign the short cut key Ctrl + Shift + c to the macro Add comments describing what this macro does in the VB window 2. Create a macro recording the advanced Filter for just those employees located in Atlanta Create a form button for this macro and call it Atlanta Assign the short cut key Ctrl + Shift+A to the macro Add comments describing what this macro does in the VB window 3. Create a macro recording the advanced Fater for ALL employees Create a form button for this macro and call it All Employees Assign the short cut key Ctrl + Shift + L to the macro Add comments describing what this macro does in the VB window 4. Create 2 macros: one that applies conditional formatting to those individuals who are managers and one that clears the conditional formatting Create 2 form buttons for the macros and call them Managers and ALL respectively Assign the short cut key Ctrl + Shift + M and Ctrl + Shift+K to the macros A B Location 1 Name 2 Adams Atlanta 3 Adamson Chicago 4 Brown Atlanta 5 Charles Boston 6 Coulter Atlanta Miami Miami 7 Elofson 8 Gillenson 9 James Chicago 10 Johnson Chicago 11 Manin Boston 12 Marder 13 Milgrom 14 Rubin 15 Smith 16 Name 17 18 19 20 21 22 Average Salary 23 Maximum Salary 26 27 28 Chicago Boston Manager Account Re Boston Atlanta Account Re Location 24 Minimum Salary 25 Total Salary C Title Trainee Manager Trainee Account Re Manager Account Re Manager Account Re Account Re Account Re Account Re Number of Employees Title D Service E Hire Date 27.4 11/24/93 29.1 3/16/92 27.4 11/24/93 29.1 3/16/92 27.4 11/24/93 28.4 10/31/92 $47,500 27.4 10/31/93 $55,000 31.4 10/31/89 $42,500 30.4 10/31/90 $47,500 29.1 3/16/92 $49,500 29.4 10/31/91 $38,500 29.1 3/16/92 $57,500 29.1 3/16/92 $45,000 27.4 11/24/93 $65,000 Service Hire Date Summary Statistics F Salary $19,500 $52,000 $18,500 $40,000 $100,000 Salary $48,429 $100,000 $18,500 $678,000 14 G Create a Macro using the Macro recorder and Visual Basic statements that will do the following: 1. Create a macro recording the advanced Filter for just those employees located in Chicago Create a form button for this macro and call it Chicago assign the short cut key Ctrl + Shift + c to the macro Add comments describing what this macro does in the VB window 2. Create a macro recording the advanced Filter for just those employees located in Atlanta Create a form button for this macro and call it Atlanta Assign the short cut key Ctrl + Shift+A to the macro Add comments describing what this macro does in the VB window 3. Create a macro recording the advanced Fater for ALL employees Create a form button for this macro and call it All Employees Assign the short cut key Ctrl + Shift + L to the macro Add comments describing what this macro does in the VB window 4. Create 2 macros: one that applies conditional formatting to those individuals who are managers and one that clears the conditional formatting Create 2 form buttons for the macros and call them Managers and ALL respectively Assign the short cut key Ctrl + Shift + M and Ctrl + Shift+K to the macros A B Location 1 Name 2 Adams Atlanta 3 Adamson Chicago 4 Brown Atlanta 5 Charles Boston 6 Coulter Atlanta Miami Miami 7 Elofson 8 Gillenson 9 James Chicago 10 Johnson Chicago 11 Manin Boston 12 Marder 13 Milgrom 14 Rubin 15 Smith 16 Name 17 18 19 20 21 22 Average Salary 23 Maximum Salary 26 27 28 Chicago Boston Manager Account Re Boston Atlanta Account Re Location 24 Minimum Salary 25 Total Salary C Title Trainee Manager Trainee Account Re Manager Account Re Manager Account Re Account Re Account Re Account Re Number of Employees Title D Service E Hire Date 27.4 11/24/93 29.1 3/16/92 27.4 11/24/93 29.1 3/16/92 27.4 11/24/93 28.4 10/31/92 $47,500 27.4 10/31/93 $55,000 31.4 10/31/89 $42,500 30.4 10/31/90 $47,500 29.1 3/16/92 $49,500 29.4 10/31/91 $38,500 29.1 3/16/92 $57,500 29.1 3/16/92 $45,000 27.4 11/24/93 $65,000 Service Hire Date Summary Statistics F Salary $19,500 $52,000 $18,500 $40,000 $100,000 Salary $48,429 $100,000 $18,500 $678,000 14 G
Expert Answer:
Answer rating: 100% (QA)
Based on the screenshots provided it seems you are working with Excel The tasks involve creating macros for filtering data and applying conditional fo... View the full answer
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date:
Students also viewed these programming questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
10. Two great circle arcs on the Earth's surface leading out of London make an angle of 20. One goes to New York City, a distance of 3,046 miles, the other to Santo Domingo in the Dominican Republic,...
-
Slovak Plumbing Company pays its support staff weekly and its plumbers on a semi-monthly basis. The following support staff payroll information is available for the week ended May 12, 2015: The...
-
In the United States, what environmental trends are supporting the development of Rover.coms business?
-
A \(30-\mathrm{kg}\) child jumps to the ground from the top of a fence that is \(2.0 \mathrm{~m}\) high. You analyze the problem using upward as the positive \(x\) direction. (a) Taking \(x=0\) to be...
-
Multiple choice questions 1. Trevor is a 50-percent partner in the Dalmatian Partnership. His basis in his partnership interest is $30,000 at the end of 2014. The partnership gives Trevor a cash...
-
Suppose you are adding two numbers (1101) and (1001) in base 2. Specify the 17 entities A. Bi. C; S; in the figure below. By A B A B A Bo A FA G Sy C G FA FA FA
-
As of December 31, 2015, the Frisbee Company had 250,000 shares of common stock issued and outstanding. On March 31, 2016, the company sold an additional 50,000 shares for cash. Frisbee's net income...
-
The ticket for an amusement park rides have different prices; 200 pesos for an adult ride and 100 pesos for a kid's ride. If a family has purchased 27 tickets in total and paid 4200 pesos, how many...
-
Suppose that you have developed a budget for next year, assuming that the costs of your variable expenditures on goods and services will increase by 1.5 percent from the previous year's levels. Your...
-
Evaluate the various types of Risk in an investment of any project and how they are associated with Investment and Returns from the below figure. Industry/Sector Risk Policy Risk External Evaluation...
-
Two current carrying conductors are placed parallel to each other. The distance between them is d. If the current in the first conductor drops by half of its original value and the current in the...
-
Under final Capitalization and Repairs regulations, a self-employed taxpayer may elect to apply a de minimis safe harbor to amounts he or she paid to acquire or produce tangible property to the...
-
1. Write a C/JAVA program to implement CRC. The program will take a sequence of binary data bits, and a divider as input. And gives the resultant data with CRC as output. (Where, divider < binary...
-
Consider the activities undertaken by a medical clinic in your area. Required 1. Do you consider a job order cost accounting system appropriate for the clinic? 2. Identify as many factors as possible...
-
Answer each of the following questions using the Solmaris Condominium Group data shown in Figures 1-21 through 1-25. No computer work is required. 1. List the owner number, last name, and first name...
-
In the following exercises, you will use the data in the TAL Distributors database shown in Figure 2-1 in Chapter 2. (If you use a computer to complete these exercises, use a copy of the original TAL...
-
Why is system availability an advantage in a distributed database?
-
What is an injunction?
-
What is the main effect of increased use of liability insurance?
-
What are the arguments in favour of imposing a wide liability on professionals?
Feynman And Computation Exploring The Limits Of Computers 1st Edition - ISBN: 1138329576 - Free Book
Study smarter with the SolutionInn App