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