Question: Can you help me please Record a macro, QUESTION16 , which will ask the user for the department of an employee (through inputbox function) and

Can you help me please

  1. Record a macro, QUESTION16, which will ask the user for the department of an employee (through inputbox function) and then calculate percentage of employees from that department who are earning above $45,000 among all employees in the database?Set up criteria on Queries worksheet, and answer should be on Queries sheet in the cell indicated. Create macro button on Queries sheet. Macro should be self-sufficient including first clearing the criteria range. Create macro button Query worksheet.

I need to know what to do step by step

Can you help me pleaseRecord a macro, QUESTION16, which will ask

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 General Management Questions!

Q:

Can you help me please Record a macro, QUESTION16 , which will ask the user for the department of an employee (through inputbox function) and then calculate percentage of employees from that...

Q:

Record a macro, QUESTION 1 , which will ask the user for the department of an employee ( through inputbox function ) and then calculate percentage of employees from that department who are earning...

Q:

2. Record a macro, QUESTION2 , that will ask the user to input the hiring date (using inputbox function) and then calculate number of employees hired on or after that hiring date (e.g., user will...

Q:

Record a macro, QUESTION1, which will ask the user for the department of an employee (through inputbox function) and then calculate percentage of employees from that department who are earning above...

Q:

I am so confused , can I get some help with this question Record a macro, QUESTION14 , that will ask the user to input the hiring/start date (using inputbox function) and then calculate number of...

Q:

Record a macro, QUESTION2, that will ask the user to input the hiring date (using inputbox function) and then calculate number of employees hired on or after that hiring date (e.g., user will input...

Q:

2 . Record a macro, QUESTION 2 , that will ask the user to input the hiring date ( using inputbox function ) and then calculate number of employees hired on or after that hiring date ( e . g . , user...

Q:

1. Go to Queries worksheet . Record a macro, QUESTION1 , which will ask the user for the STATES and GENDER of customers (using InputBox functions) and then calculate percentage of people that meets...

Q:

Record a macro which will ask the user for the department of an employee (through inputbox function) and then calculate percentage of employees from that department who are earning above $45,000...

Q:

1. Record a macro, named QUESTION1 , that will help the user of this excel file calculate percentage of employees who have a salary of $45000 and are from a specific department (i.e. the user can...

Q:

Show fzdz=zdz=4+2 i where C1 is the line segment from-1-i to 3+ i and C2 is the portion of the parabola x= y + 2 y joining - 1-i to 3 + i. Make plots of two contours C1 and C2 joining -1 - i to 3 + i.

Q:

Let H be a hyperplane in a linear space that is not a subspace. Then there is a unique linear functional f X' such that H = {x X: f (x) = 1} On the other hand, where H is a subspace, we have the...

Q:

What's the value of count?A What's the value of evenSum? What's the value of oddSum? ? A Whatic the value of i ?

Q:

NEED DETAIL ANSWER: Q#4. Give a brief summary of your selected organization, what have you found in its management (Discuss the key aspects of management of your report) Q#5. What do you think how...

Q:

The work role: This consists of service to others at your workplace.

Q:

The role of society: This consists of service to the local community, society and nature.

Q:

13. Think about a relationship conflict you have had in your workplace or home situation. Try to interpret the conflict from the following logical levels: a. Purpose b. Role c. Values d. Competence...