Question: Record a macro, QUESTION 1 , which will ask the user for the department of an employee ( through inputbox function ) and then calculate
Record a macro, QUESTION 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 $ 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 selfsufficient including first clearing the criteria range. Create macro button Query worksheet.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
