Question: I need help writing a Macro that will highlight all employees with first name starting with S and earning between $30,000 and $55,000 (both salary

I need help writing a Macro that will highlight all employees with first name starting with S and earning between $30,000 and $55,000 (both salary inclusive), or all employees born after 1/1/1981 (regardless of name and salary) in GREEN color (ColorIndex = 4). (Uses Left or Like function and Do-Until loop).

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!

Prepare the couple's federal income tax return, Form 1040 for the year ended December 31, 2021, plus any additional schedules necessary. $1040 Department of the Treasury -Internal Revenue Service...

4. Write (not record) a Macro, QUESTION4, that will highlight records in blue color (ColorIndex = 5) with all employees that are either in Marketing or Accounting departments and those employees...

how can do the payroll register for Dec 13? how to do the employee gross pay for December 31? Required information Appendix A Continuing Payroll Project: Wayland Custom Woodworking (1 Month, Part 1)...

Bus299 Assignment: West Coast Sales (WCS) Database 1. Each employee at WCS has an email address which is always their L..e@wcs.com. Using text functions, put each employee's email address in column...

Wayland Custom Woodworking is a firm that manufactures custom cabinets and woodwork for business and residential customers. Students will have the opportunity to establish payroll records and to...

come Tax Return i Help Save & Exit Submit --------- --- - - ---------- -------- --- - ---------- --------- -- Required information The following information applies to the questions displayed below.)...

8-1 Discussion: Writing Your Resume Profile For this discussion, you will be writing a professional profile. You will need to find a job posting that interests you and then write the professional...

a brief summary what was understood on the aspect of the causes or effects of segregation in city ( any kind of city within US). 1000word. Thank you REFERENCE: CHAPTER 5 Residential Segregation and...

Under the Sarbanes-Oxley Act, what must the financial statement auditor do in relation to the companys internal control?

What are some tests of data communications controls?

Which of the following statements are true with regard to a cash budget? The three sections of a cash budget, in order, are the cash collections schedule, the disbursements schedule, and the cash...

use australia law , please help yes use australia law aapko australia law and it's urgent so help please . thank you 1. Susan is a registered tax agent. For each of the following scenarios, identify...