"****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 *