|
Data validation list from another worksheet?
Is it possible that the value list for data validation be populated from another worksheet? Puneet Arora -- puneetarora_12 ------------------------------------------------------------------------ puneetarora_12's Profile: http://www.excelforum.com/member.php...o&userid=18406 View this thread: http://www.excelforum.com/showthread...hreadid=385727 |
Sure is! Use a named range as described he
http://www.officearticles.com/excel/...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "puneetarora_12" <puneetarora_12.1rvcyd_1120856702.7664@excelforu m-nospam.com wrote in message news:puneetarora_12.1rvcyd_1120856702.7664@excelfo rum-nospam.com... Is it possible that the value list for data validation be populated from another worksheet? Puneet Arora -- puneetarora_12 ------------------------------------------------------------------------ puneetarora_12's Profile: http://www.excelforum.com/member.php...o&userid=18406 View this thread: http://www.excelforum.com/showthread...hreadid=385727 |
Thanks a ton !! :) -- puneetarora_12 ------------------------------------------------------------------------ puneetarora_12's Profile: http://www.excelforum.com/member.php...o&userid=18406 View this thread: http://www.excelforum.com/showthread...hreadid=385727 |
| All times are GMT +1. The time now is 03:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com