moving a drop down to another worksheet

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

Guest

Okay, so I have created a drop down box, but how can I move it to another sheet, whenever I copy and paste it or copy and paste special, all it does is copy the first item and not the list. anyone have any ideas???
 
Hi

When you used Data.Validation.List, then PasteSpecial.Formats.
NB! The list must be defined as named range, and data validation list source
must refer to this named range. You can't refer to some range on another
worksheet directly in list's source.

Arvi Laanemets


Nat said:
Okay, so I have created a drop down box, but how can I move it to another
Click to expand...
sheet, whenever I copy and paste it or copy and paste special, all it does
is copy the first item and not the list. anyone have any ideas???
 

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

Drop Down with dynamic named range offsheet source list 14
Excel Move or Copy Stopped Working? 0
Dependent drop down dynamic range formula, off sheet. 7
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
How do I copy cells containing drop downs? 3
Drop down list from another worksheet 2
Alt codes 4
Formatted cell column in drop down list 1

Back
Top