Hi Vijayajith,
Data validations can be created from one workbook to another
workbook.
Example:
Attached are the two workbook
1. Source_Book.xlsx
2. My_Book.xlsx
My list is available in Source_Book - sheet1 -
range("A1:A5")
and my validation is in workbook - My_Book.xlsx - Sheet1 -
Range("A1")
Procedure:
First create a name range in the workbook Source_Book with the
range "A1:A5" as "Month"
and now open the workbook My_Book and define a new name as My_List
as "Source_Book.xlsx!Month"
Now you can use this new define name "My_List" as your
validation list
However, it now not recommended to use a validation list from a
different workbook as the user will not be able to use the validation if the
workbook which carries the list is not open.
Best Regards,Kaushal Kumar
Date: Tue, 15 Nov 2011 19:20:58 +0530
Subject: $$Excel-Macros$$ Help me
From: vijayajith...@gmail.com
To: excel-macros@googlegroups.com
Hi Gurus,
Is this possible to do data validation from one workbook to another workbook ?
Can you give me one example?
Thanks
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
My_Book.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Source_Book.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
