Question: I need help with VBA code I have two excel Sheet name Sheet1 = Employee Data Part I Sheet2 = Employer Data Part I &

I need help with VBA code

I have two excel Sheet name

Sheet1 = Employee Data Part I

Sheet2 = Employer Data Part I & II

I already merge and made another sheet clled Merge-Ready

I need a for loop that will look at at my columns so I can copy from Sheet2 to Merge Ready

I was trying to make my condition that if the State is equals to OH then copy all values of row from Sheet2 to Merge-Ready

How can I make this condition?

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 Databases Questions!

Q:

Excel 1. Insert a module and create a subroutine named Receipt(). 2. Place a button with the name "Generate Receipt" that would link to this subroutine when clicked. Do the following parts from 3 to...

Q:

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...

Q:

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 Querying in Excel...

Q:

Exam 3-Scaling Up with VBA Learning Objective: In this assignment, you will use your recently acquired knowledge of Excel VBA coding to scale up the analysis from the previous exercise. You should be...

Q:

Exam 3-Scaling Up with VBA Learning Objective: In this assignment, you will use your recently acquired knowledge of Excel VBA coding to scale up the analysis from the previous exercise. You should be...

Q:

'a. Using the properties window in the VB editor assign the code name wsEx2 to the sheet with tab name Sheet1. 'b. Using VBA code and the code name for worksheet Sheet1, make this worksheet the...

Q:

Chapter 9 Excel Assignment_Instructions & Template.xlsx Sheet2 Sheet3 Sheet1 K Instructions: 1) use the information in Part A to complete the Payroll Register Table in Part B. Remember to use...

Q:

Chapter 9 Excel Assignment_Instructions & Template.xlsx Sheet2 Sheet3 Sheet1 K Instructions: 1) use the information in Part A to complete the Payroll Register Table in Part B. Remember to use...

Q:

Please help answer part a to f: Ensure the following Corrections are used: There is an error in Part B. should read the bottom right corner in cell D38. There is an error in Part D. should read 2017...

Q:

help me Excel_Comprehensive_Capstonel_Wint ect Description: s project, you will apply skills you practiced from the objectives in Excel Chapters 4 through 10. You will develop a book for Frank Osei,...

Q:

The path of a projectile fired from level ground with a speed of v0 feet per second at an angle a with the ground is given by the parametric equations x = (v0 cos )t, y = - 16t2 + (v0 sin )t a. Show...

Q:

You measure the period of a physical pendulum about one pivot point to be T. Then you find another pivot point on the opposite side of the center of mass that gives the same period. The two points...

Q:

The gain on disposal of fixed assets consists of the accounting gain on the sale of some land on May 3 1 , 2 0 2 4 , and the sale of a limited life license ( see details below ) . XYZ LTD . purchased...

Q:

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Q:

LAST WORD Under what law and on what basis did the Federal district court find Microsoft guilty of violating the antitrust laws? What was the initial district courts remedy? How did Microsoft fare...

Q:

KEY QUESTION Suppose a tax is such that an individual with an income of $10,000 pays $2000 of tax, a person with an income of $20,000 pays $3000 of tax, a person with an income of $30,000 pays $4000...

Q:

KEY QUESTION Explain the following statement, using the MB curve in Figure 28.6 to illustrate: The optimal amount of pollution abatement for some substances, say, water from storm drains, is very...