Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. i am getting a data validation error after i do th

I am getting a data validation error after I do the following----In cell C3, add...

60.1K

Verified Solution

Question

Accounting

I am getting a data validation error after I do the following----In cell C3, add a data validation list that accepts only the values in the range I3:I203. I have to make a Macro using that Cell C3. The information transfers to the new sheet correctly but it gives an error message. I did an error checking and it says that the value in C3 does not match the value in the list(I3:I203). I have tried multiple ways to resolve this and I do not know what I am doing wrong. Help please

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Accounting
1.2K views

Using the Computer to DiscoverIntentional Financial Misstatements in Transactions and AccountBalances. AMI International is...Using...

Finance
1.2K views

1. What is trade dress? 2. What is the USDA? What is the purpose of the...

Physics
1.2K views

What is happening that makes the sky look blue? A. Only blue light can get through...

Physics
1.2K views

explain the importance of knowledge of quantitative techniques to the ethical outcomes of quantitative research

Physics
1.2K views

a Magnetic field at axial point which is well inside the solenoid Honl 2 b...

Basic Math
1.2K views

Which expression below can be obtained from 10sinx by using a power reducing formula?Select the...

Basic Math
1.2K views

Line A has a slope of -2/5 and passes through the point (2, 6).Line B...

Algebra
1.2K views

Question 2 Evaluate the function f x logs x at Q 2

Accounting
1.2K views

1-How do you analyze the dependency ratio considering the ideas that it measure of the...

Accounting
1.2K views

Required information Great Adventures Problem AP7-1 (The following information applies to the questions displayed below.)...

Accounting
1.2K views

Made a $10,000 sale to Paul/cost of goods is $6,000, but instead of Paul paying...

Finance
1.2K views

How can a voluntary dividend reduction lead to a higher share price?