Re: ]] XL-mania [[ validation

Good question,

trik-nya simpel kok,,
pada File2.xls, alamat Link "=[File1.xls]Sheet1!$A$1:$A$4" dicopy paste ke Data Validation > List > Source


>semoga bermanfaat

---

From: "Ardo, Ronald " <ronald.ardo@siemens.com>
To: XL-mania@yahoogroups.com
Sent: Fri, June 11, 2010 6:24:42 PM
Subject: RE: ]] XL-mania [[ validation

tanya lagi ... secara createnya di xls 2007 ya ...?

karena ketika di edit validationnya ga bisa ... atau gunakan trik apa ya ?

Salam

Ardo

---

From: XL-mania@yahoogroups.com [mailto:XL-mania@yahoogroups.com] On Behalf Of anton suryadi
Sent: Thursday, June 10, 2010 1:11 PM
To: XL-mania@yahoogroups.com
Subject: Re: ]] XL-mania [[ validation

monggo dipun sakecaaken rumiyin,

File terlampir


>semoga bermanfaat

---

From: ايكوكورنياوان <eko.betonjkt@gmail.com>
To: XL-mania@yahoogroups.com
Sent: Wed, June 9, 2010 10:41:28 AM
Subject: ]] XL-mania [[ validation

 

hai xl-mania,... ane pengen tau, gmn caranya Validation List dengan data pada alamat file yang berbeda...

mantur nuwun, sunggeh sewu ..