validation, seperti halna vlookup dll bisa diambil dari file lain. -sol- On 10/29/07, Anton Setiawan <[EMAIL PROTECTED]> wrote: > > Met pagi semuanya, > begini mas/mbak/om/tante, semisal saya punya data excel contoh : > 1. mie goreng > 2. mie telur > 3. telur ayam > terus pas saya ketik "te" langsung keluar pilihan menu (telur ayam)dari > data yg saya punya. gimana ya cara bikin formulanya ? > > nb : data saya koneksikan dengan "validation data" > trus da lgi nich, apa validation data hanya bisa di kases dalam 1 sheet yg > sama saja? bagaimana klo datanya ada di lain file excel? tolongin donk... > > thx be4 > > [Non-text portions of this message have been removed] > > >
[Non-text portions of this message have been removed] -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ITCENTER/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/