I am trying to create a drop down list that I can make without using the data
validation command. I have another function that moves the contents of the
cell at year end, but I don't want the validation to come along with it.

Brian,

I know if you do a Paste Special, rather than just a copy and paste, and
select Values, that you won't get the Validation. I didn't know what you were
using to move your data to the new location.

"Brian T" wrote:

I am trying to create a drop down list that I can make without using the data
validation command. I have another function that moves the contents of the
cell at year end, but I don't want the validation to come along with it.

I have a macro set up to move the values over. I have over 500 rows to go
through and not all of those will have new data.

"Marge" wrote:

Brian,

I know if you do a Paste Special, rather than just a copy and paste, and
select Values, that you won't get the Validation. I didn't know what you were
using to move your data to the new location.

"Brian T" wrote:

I am trying to create a drop down list that I can make without using the data
validation command. I have another function that moves the contents of the
cell at year end, but I don't want the validation to come along with it.