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???
 
Back
Top