How to copy drop down list to next sheet

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

T. Valko

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:

 

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

Filtered drop down list 2
Drop down list and macros? 1
how to create drop down list from one excel file to another excel. 2
How to Display 12.5 but not 25.0 (drop .0’s) 5
Copy dropdown list 1
Dependent drop down dynamic range formula, off sheet. 7
Drop Down List Problem 1
Drop down list question 1

Top