Question: systems and information 5. Write a macro In column labeled as G or * (in Data sheet) - If a customer's first name begins with

systems and information

5. Write a macro In column labeled as "G or *" (in "Data" sheet) - If a customer's first name begins with letter G then write their last name, otherwise put asterisks. Also, create a macro button for it in "Data" sheet (at the bottom) so that it is easier to re-run the macro

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!

Write a macro In column labeled as Supplier first letter (in Data sheet) - If a suppliers name begins with letter S then write their last name, otherwise put asterisks. Also, create a macro button...

INTRODUCTION This exercise is comprised of four parts. Part 1 covers automated routines macros in Excel to rearrange and transform data, Part 2 covers Pivot Table: Data Sets Cross-Tabulation and...

2. (2 points) Write a query to display the number of rows in the line table. 3. (3 points) Write a query to show everything in the product table. Add a field called Assets to calculate quantity *...

I have problems understanding this case study for database. can someone help me solve this. Deliverables: 1. Create a list with the main business rules 2. Identify the main Entity types and their...

1. Write a macro using the concatenate function to provide a full name of each customer in Column L . The last name should come first and first name should come after it. However, there should be a...

Hi I need help with this project that I am doing. It has to be in C language and I don't what to do. This is for my Data Structure course. Please it has to be in Language of C. Programming Assignment...

Step 1: Import and Clean Up Text File Download starting student Excel file and the text file. Open the starting Excel file and navigate to Sheet1. Import the text file by using the Get External Data...

A B D K L M N O Month Year |Day 10 Quantity 7 20 25 380 220 4 280 1 380 00 ONS VAN 6 26 200 DO NOT MAKE ANY MODIFICATION (CHANGING THE ORDER OF THE COLUMNS, ADDING A NEW CALCULATED COLUMN ETC.) ON...

could someone please help me these access assignment Accounting Information Systems Access Assignment S&S Revenue Database Introduction to Microsoft Access: Microsoft Access is representative of...

PROJECT DESCRIPTION Patrick Fitzgerald is the director of Career Development at Finn Technical Institute, a local community college. The Institute offers workshops on resume writing, interview...

Q-1- For a Shaft of diameter d, acting Torque T and Shear modulus of the material is G. Determine the angle of twist, of length of shaft is 1m. Also find the maximum shear strexp developed in shaft.

Sharon Coulson was recently hired as the new director of accounting at SunShine Minerals. Sharon's first responsibility was to examine the internal control procedures and implement stronger controls...

Question 1 6 5 pts Good working knowledge of valuation can help the entrepreneur avoid breakdown in negotiation when seeking VC funds' investments. True False

Premise: Using a dictionary and list, create a set of key / value pairs that consists of a musical database. The key / value pairs should consist of Artist Name: Song Names pattern. For example, EACH...