Question: I have attached 2 screen shots , this is an excel file and the three sheets are customers , products and then queries. I need

I have attached 2 screen shots , this is an excel file and the three sheets are customers , products and then queries. I need help with this question, can I get a step by step explanation please? I am very confused

Go to Queries worksheet. Record a macro, which will ask the user for the States of customers (using InputBox function) and then calculate percentage of customers from that states have sales value greater than $150?Set up criteria on Queries worksheet, and answer should be on Queries sheet in the cell indicated. Create macro button on Queries sheet.

The first sheet is Customers the second sheet is products and the third sheet queries.

I have attached 2 screen shots , this is an excel file

and the three sheets are customers , products and then queries. I

\f\f

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!

Hi, I need help with my Financial & Management Accounting Assignments. I've done the project assignment and attached 2 excel file with 'GRAY' highlighted columns which are answered by me. Please...

There is no need to round as you are doing this in excel. All workings must be dynamic. An example of what dynamic means has been provide and has been explained in detail. You have recently been...

Sparkles Dessert Cafe Please read the instructions carefully and provide what is being requested. A new client of yours, Bailey Waters wants to open a small dessert cafe selling cupcakes, pie slices,...

Rusiness Gase - Financingand Investment Decision Anzlysis Written by - lohn Mentler, Oregon State University A.Promining Start: In the sumuner of 2016. Photonics, a leader in the production of...

PROJECT MANAGEMENT Term Project (read carefully, take your time. Do not forget to mention the ref-erences you used) Note : You may not be familiar with all of the technical aspects of the project,...

Accounting Patrice sheet, lengthy and need some help PART 1: ORIGINAL PROBLEM DATA(1ST Excel File): CHECK FIGURES: MOH $66,800 underapplied NOI: $136,400 Cedar Works, located in Rockport, Maine...

You have recently been appointed as a senior accountant at an automobile company. You notice that no one has created method to apply overhead to the products, and they are currently being sold...

In the USA, it is (generally) a statewide policy for universities to maintain control of all non- consumable items worth more than $1,500. The College of Engineering, along with all other colleges at...

This section in the picture is what i am needing. MergerETL Memo DATE 9/5/2018 MEMORANDUM FOR Young Jolly, LLC Merger Project Com FROM SmartBuy SUBJECT Merger Project ETL Parameters Now that ther e...

Foreign saving is used for domestic investment when foreigners engage in foreign direct investment. foreign portfolio investment. either foreign direct investment or foreign portfolio investment....

Students must use APA-style citations in their writing assignments. For detailed information on how to properly cite your work, please refer to the Student Resources tab on the main page of the...

stands to become more profitable ( in terms of U . S . dollars ) when the U . S . dollar appreciates in value against the Brazilian real. is unaffected by changes in the valuation of the euro against...

SIMAD UNIVERSITY Class: BACC25 Subject: Islamic Accounting Instructions: a) Follow The Instructions. Midterm Exam Instructor: All Ibrahim Date: 6-4-2022 b) You Have 1.5 Hrs. To Complete This Test. c)...

5. The next time you read somethinga magazine article, a political blog, a work of nonfiction, a chapter in a textbooktake time to think about the research presented in it. What kinds of research did...

2. Think back to a memorable speech youve witnessed, either in person or through the media. What kind of speech was it? Was the speaker trying to inform, persuade, or celebrate? Was he or she...

3. Tune in to a few news punditsfor example, Bill OReilly, Rachel Maddow, Randi Rhodes, or Rush Limbaughon the radio, on television, or online. Listen carefully to what they say, and consider how...