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 ClickPaste Specialselect Validation
and give ok.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"billf" wrote:

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.