makasih mbat citi, tapi ada gak cara yang pake rumus makronya? biar nampak lebih keren gitu.. hehehe ;)
siti Vi wrote: > > cara lain... > *=INDIRECT(ADDRESS(* > * FLOOR(ROW(A1)-1,2)/2+2,COLUMN(A1),2,1,IF(MOD(ROW(A1),2)=1,"a","b")))* > FORMULA INI > ** *Universal *(cukup ditulis di satu cell dulu misal C17) lalu dicopy > ke cells di bawah > & kanan nya dlm area data > ** *Bukan Array Formula* > ** *Tidak memerlukan kolom bantu*. > ------------------------------------------------------------------------ > > ----- Original Message ----- > *From:* t0f1q <mailto:t0f1...@gmail.com> > *To:* belajar excel <mailto:belajar-excel@yahoogroups.com> > *Sent:* Sunday, February 21, 2010 6:28 AM > *Subject:* [belajar-excel] menggabungkan dua data yang berbeda > secara selang seling > > halo lagi master excel, saya ada persoalan bagaimana yah > menggabungkan > dua data pada 02 sheet menjadi 01 sheet dimana data tersebut terisi > secara selang seling antar masing2 sheet. > mohon bantuannya yah > thanks > > ------------------------------------ /---------------------------------------------------------------\ | bergabung ke milis (subscribe) | | kirim mail kosong ke: belajar-excel-subscr...@yahoogroups.com | | | | posting ke milis | | kirim kan ke: belajar-excel@yahoogroups.com | | | | melihat file archive / mendownload lampiran | | http://www.mail-archive.com/belajar-excel@yahoogroups.com/ | | | | menhubungi moderators & owners: | | belajar-excel-ow...@yahoogroups.com | | | | ExcelWeb <http://opi.110mb.com/> | \---------------------------------------------------------------/Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/belajar-excel/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/belajar-excel/join (Yahoo! ID required) <*> To change settings via email: belajar-excel-dig...@yahoogroups.com belajar-excel-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: belajar-excel-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/