Drop down list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Created invoices in Excel - not working in Drive 1
drop down list 3
Excel Drop Down Lists 9
customize drop-down box 1
Drop Down Lists 2007 10
How do I create a drop down box within a drop down box? 1
Remove blank cells from data validation drop down box 3
Data Validation 1

Back
Top