copying data validation to another workbook



am i able to copy my data validation cell that i created in one workbook over
to a new excel file not associated with the original. I have no problem
copying validation from one area to another within a workbook but can't seem
to bring the validation commands over to a new file.


Just select the column or range on which you are having the Data Validation
and give Cntrl+C and Press Cntrl+N to open a new workbook or open the
workbook on which do you want to paste the Data Validation. Now select the
Column or Range of cells and do Right Click>>Paste Special>>select Validation
and give ok.

Remember to Click Yes, if this post helps!


Thanks for the quick response, I'll give it a try. That is the procedure I
do whenever I want to paste data validation to another area of the workbook,
however, when I tried that with a new file I thought I got the paste text
dialog box instead.... I'll let you know how it turns out. Thanks

Gord Dibben

You have two instances of Excel running with a workbook in each instance.

These will not communicate.

Close one instance and open both workbooks in a single session of Excel.

Gord Dibben MS Excel MVP

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