Copy dropdown list

L

Learning VBA

Is there a way to copy a drop down validation to other sheets?

On each sheet I have 2 dropdown validation lists:

1 at cell E2
and the other at cell E42

I would like to be able to copy these to another 30 sheets in the exact same
cells on each sheet.
 
L

L. Howard Kittle

I believe that is possible.

Set up your data validation lists to accept a named range, that is select
your lists and name them, MyList1, MyList2 and such.

Then in the data validation source box enter =MyList1 or MyList2 etc.

Now copy the cell with the data validation on your present worksheet and
past on any worksheet. I think that will work for you.

HTH
Regards
Howard
 

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

Top