kalo sering pake Exel gabung ajah ke
[EMAIL PROTECTED]
----- Original Message -----
From: Deri Fasa
To: ITCENTER@yahoogroups.com
Sent: Monday, July 07, 2008 4:57 PM
Subject: [ITCENTER] Tanya excel
Alloo.. para suhu ITEr.....
mo tanya soal excel dong.., saya sedang merapikan database
yang jumlah recordnya lumayan...banyak..
Gimana ya cara..mengisi record kosong(dengan record di atasnya) secara
otomatis ( spt dalam tabel berikut)
ilustrasi tabelnya :
(Field) ---> Account Tanggal Qty
Tglexp .... dst
(record2) ----> 0010002 03/01/2000 1321
05/02/2003
0020011 03/01/2002 2712
09/01/2004 *kosong1* 03/03/2002
1500 09/01/2004 *kosong2*
03/04/2002 1672 09/01/2004
0010007
03/01/2005 1321 12/05/2008
* kosong3*
04/01/2005 890 12/05/2008
*kosong4 * *kosong5 *
220 12/05/2008
0010002 03/01/2005 1321
09/01/2007
.......
.......
...dst........................................
saya ingin record2 : kosong1 terisi dg (0020011 record diatasnya)
kosong2 terisi dg (0020011 record
diatasnya)
kosong3 terisi dg (0010007 record diatasnya)
kosong4 terisi dg (0010007 record
diatasnya)
kosong5 terisi dg (04/01/2005 record
diatasnya)
Gimana ya biar terisinya secara otomatis, karena kalo kopi satu2 gitu...
wow..
mohon pencerahannya ya...
Tq..
[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/
