data validation
how can i use data validation for sheet1 to other sheet
sheet2. ****al |
data validation
"****al" wrote in message
... how can i use data validation for sheet1 to other sheet sheet2. Hi ****al, If you mean you want to create a data validation list on one sheet that points to a range on another sheet, give the list a book-level range name (highlight the list and type a name into the box directly to the left of the formula bar). Then you can enter =MyList (or whatever you named it) into the Source entry in the data validation dialog. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * |
All times are GMT +1. The time now is 10:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com