copying data validation to another workbook

[billf]

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.

 

[Ms-Exl-Learner]

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!

 

[billf]

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