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