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.

copying data validation to another workbook
 

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.

copying data validation to another workbook
 

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

"Ms-Exl-Learner" wrote:

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.

copying data validation to another workbook
 

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

On Sun, 14 Mar 2010 10:53:01 -0700, billf
wrote:

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

"Ms-Exl-Learner" wrote:

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.