Question: 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

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

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

PROJECT STEPS 1 . Tarif Hajany is the admissions director at the Abernathy Academy, a private secondary school in Roswell, Georgia. He is developing an Excel workbook to track and record tuition...

This is to be done in Excel. The class in for accounting information system. Go to the Entry Form worksheet. The Admissions staff will use this worksheet to enter tuition payments and summarize...

Hi, I'm having an issue with this Simnet project and I was wondering if anyone could help me. There is only one issue: Step 3a, in the instruction pdf that I have attached. When my project is graded...

1)Tarif Hajany is the admissions director at the Abernathy Academy, a private secondary school in Roswell, Georgia. He is developing an Excel workbook to track and record tuition payments from...

This is to be done in Excel. The class in for accounting information system. Go to the Entry Form worksheet. The Admissions staff will use this worksheet to enter tuition payments and summarize...

I need help to sove it with explanation. Create the following range names for the indicated cells: SelectedStockName for C2 StockNames for P3:AC3 Use Data Validation on the SelectedStockName cell to...

EX 12-37 EX 1241 structure of the workbook. Do not specily a passwu 8. In the Payment Form worksheet, use data validation to add a validation list to cell C4 using the data in the range H4:H451 of...

The form "New Employee Entry Form" is used by human resources to collect data for new U . S . employees. Perform the following tasks: 1 ) In cell C 3 , add validation for the "Today's Date" field. It...

Can someone explain the steps of doing this? You enjoy drinking coffee but are particular about the temperature (T) of your coffee. If the temperature is greater than or equal to 70 degrees Celsius...

2. In the Documentation sheet, enter your name and the date. 3. In the Payment Form worksheet (which displays the total amount pledged, paid, and owed by donors), use an IFERROR function in cells F4...

At high noon, the Sun delivers 1 000 W to each square meter of a blacktop road. If the hot asphalt loses energy only by radiation, what is its equilibrium temperature?

A grating has 600rulings/mm and is 5.0 mm wide. (a) What is the smallest wavelength interval it can resolve in the third order at = 500 nm? (b) How many higher orders of maxima can be seen?

EXERCISE 7-13. Dropping a Product Line Computer Village sells computer equipment and home office furniture. Currently, the furniture product line takes up approximately 50 percent of the company's...

To investigate the impact on NPV of a change in one variable, you would employ Blank _ _ _ _ _ _ . Multiple choice question. sensitivity analysis "what - if " analysis scenario analysis Monte Carlo...

4. Clicking on WebLink 7.3 will take you to the Powerful Non-Defensive Communication site, which offers exercises to assess and improve your skill in creating supportive communication climates.

1. Redford Williams, M.D., and Virginia Williams, Ph.D. (1993). Anger kills: Seventeen strategies for controlling the hostility that can harm your health. New York: HarperPerennial. This is...

2. To read Jack Gibbs original paper on defensive and supportive communication, go to the books online resources for this chapter and click on WebLink 7.1.