This is homework, I am so lost. Here is the problem:
1. Write a macro, Q_1, which will ask the user for the division of an employee and then calculate percentage of employees from that division who are earning above $40,000 among all employees? Set up criteria on Queries worksheet, and answer should be on Queries sheet in the cell indicated. Create two macro buttons, one each on Database and Queries sheet. Macro should be self-sufficient including first clearing the criteria range.