How to copy drop down list to next sheet

  • Thread starter Thread starter Iraj
  • Start date Start date
I

Iraj

Hi all:
I have created a drop down list in sheet 1. But when I copied the cell with
list to the sheet 2 in the same work book, doesnt show any list.

Is there any way to copy it to other sheets in a ame book?
Cheers .
 
Give the source for the list a defined name then it should work after you
copy/paste it.

Watch this 5 min video:

How to setup a data validation drop down list:

 
Back
Top