Drop down list

B

Brian T

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

Marge

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

Brian T

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