Dear Pak Hendrik, Seperti contoh yang telah saya kirimkan misal, saya ingin pilih JKL dengan mengaktifkan in-cell-dropdown tanpa menggeser scroll kebawah hanya dengan ketik j maka dengan sendirinya akan terpilih JKL dan jika ada awalan j yanglain akan berada dibawah atau diatasnya dengan demikian kita akan memudahkan untuk input data. Maaf ....contoh soal mestinya nama barang atau yang lain sehingga tidak membingungkan.
Salam Abdul Hamid ----- Original Message ----- From: hendrik karnadi To: [email protected] Sent: Tuesday, April 13, 2010 3:03 PM Subject: Re: [belajar-excel] Data Validation Dear Abdul Hamid, Sepanjang pengetahuan saya, seluruh data yang berbentuk alphabet berawalan a sd z. Artinya alphabet apapun yang kita ketik akan keluar lis yang sama. Jadi apa yang masih dapat divalidasi ? Salam, Hendrik Karnadi ------------------------------------------------------------------------------ From: Abdul Hamid <[email protected]> To: [email protected] Sent: Tuesday, April 13, 2010 15:11:13 Subject: [belajar-excel] Data Validation Mohon bantuan bagaimana supaya Data Validation_List, apabila diketikkan hurup a - z data langsung pada character yang berawalan a sd z. Mudah2han pertanyaan bisa dipahami dan thanks atas bantuannya. Salam Abdul Hamid D ------------------------------------------------------------------------------ New Email names for you! Get the Email name you've always wanted on the new @ymail and @rocketmail. Hurry before someone else does! DISCLAIMER --------------- "This email and any files transmitted with it are private and confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error please notify the system manager. If you are not an intended recipient, you are hereby notified that any disclosure, copying, or distribution of this email, and/or taking any action based on its content, is strictly prohibited, and you should: (i) immediately delete this email and its attachments from your system, and (ii) inform the sender by reply email that you are not an intended recipient. Please note that any views or opinions presented in this email are solely those of the author/sender and do not necessarily represent those of ANJ Agri Group. ANJ Agri Group does not accept (i) any liability for its employee's communications that are against ANJ Agri's core values and/or outside the scope of employment and (ii) any damage caused by any virus transmitted by this email. Details can be found at: http://www.anjagri.com/disclaimer.htm";
<<clip_image002.jpg>>
