Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 25, 2024

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

Step: 1

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

Step: 3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Databases And Information Systems 22nd European Conference Adbis 2018 Budapest Hungary September 2 5 2018 Proceedings Lncs 11019

Authors: Andras Benczur ,Bernhard Thalheim ,Tomas Horvath

1st Edition

3319983970, 978-3319983974

More Books

Students also viewed these Databases questions

Question

★★★★★

Nicotine contains two nitrogens, one in a pyridine ring and one in a pyrrolidine ring. It reacts with one equivalent of HCl to form a crystalline salt, C10H15N2Cl. Draw its structure. Nicotine also...

Answered: 1 week ago

Question

★★★★★

Suppose Frances did not have full car insurance, and she drove very cautiously because she knew she would have to pay for any damage to her car. Now that Frances has car insurance, she tends to speed...

Answered: 1 week ago

Question

★★★★★

1. LaunchPad for Real Communication offers key term videos and encourages selfassessment through adaptive quizzing. Go to bedfordstmartins.com/realcomm to get access to: LearningCurve Adaptive...

Answered: 1 week ago

Question

★★★★★

Clampett Oil purchases crude oil products from suppliers in Texas (TX), Oklahoma (OK), Pennsylvania (PA), and Alabama (AL), from which it refines four end-products: gasoline, kerosene, heating oil,...

Answered: 1 week ago

Question

★★★★★

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

Answered: 1 week ago

Question

★★★★★

You wish to borrow $2,000 to be repaid in 12 monthly installments of $189.12. a). What is the monthly interest rate? b). What is the APR of the loan? c). What is the EAR of the loan

Answered: 1 week ago

Question

★★★★★

25. A vector 20 inches in length forms angles of 58 and 22 with two component vectors. Find the magnitudes of the two vectors. The magnitude of one vector = ? A. 17.2 inches B. 23.2 inches C. 12.5...

Answered: 1 week ago

Question

★★★★★

Kathryn is conducting a needs analysis to determine what financial losses organization ABC faces as a result of certain changes in governmental policies. Kathryn is most likely: A leader in the...

Answered: 1 week ago

Question

★★★★★

If Quality Airline cuts its domestic fares by 20%, A) profit will increase by 20%. B) a profit can only be earned by decreasing the quantity of flights. profits can be maintained either by increasing...

Answered: 1 week ago

Question

★★★★★

You have an opportunity to invest in Australia at an interestrate of 0.070. Moreover, you expect the Australian dollar (A$) toappreciate by 0.020. Your effective return from this investmentis:

Answered: 1 week ago

Question

★★★★★

HR Management at InnovateTech Solutions InnovateTech Solutions is a dynamic and forward-thinking technology company, specialising in software development. It was first established in 2021 and has...

Answered: 1 week ago

Question

★★★★★

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

Answered: 1 week ago

Question

★★★★★

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

Answered: 1 week ago

Question

★★★★★

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

Answered: 1 week ago

Previous Question Next Question