Hai Dwi, Untuk membutnya secara otomatis terisi, anda harus menggunakan VBA, akan banyak sekali formula yg di gunakan jika kita menggunakan formula excel. Untuk membuatnya dengan VBA, anda harus bisa menysun data yang ada sesuai dengan kaidah database sehingga mudah untuk di olah.
Data yang anda berikan, terus terang saya ngga mengerti maksudnya artinya mana input mana outputnya. Coba anda buatkan lagi dengan contoh yang lebih jelas, artinya mana yang mesti di inputkan dan mana yang menjadi outputnya, kalo bisa buatkan dengan 2 atau 3 contoh saja karena selanjutnya pasti akan mengikutinya (artinya cukup denga 2 atau 3 pembeli / peternak) Dengan contoh yang jelas dan detail, mungkin teman2 di sini akan membantu. TerimaKasih. Pada Jum, 29/1/16, 'dwi' [email protected] [belajar-excel] <[email protected]> menulis: Judul: [belajar-excel] FW: 150106 smd- Payment Control.xlsx [1 Attachment] Kepada: [email protected] Cc: "'Mr. Kid'" <[email protected]>, [email protected] Tanggal: Jumat, 29 Januari, 2016, 8:50 PM Minta bantuannya para pakar Excel -----Original Message----- From: dwi wahyu erwinsyah [mailto:[email protected]] Sent: Monday, January 25, 2016 8:29 AM To: '[email protected]' Cc: '[email protected]' Subject: FW: 150106 smd- Payment Control.xlsx Bersama ini saya kirim ulang, minta bantu pak dan rekan2 Master XL Terima kasih -----Original Message----- From: dwi [mailto:[email protected]] Sent: Tuesday, January 12, 2016 1:54 PM To: [email protected] Cc: 'dwi wahyu erwinsyah' Subject: FW: 150106 smd- Payment Control.xlsx Dear mas nang agus Bersama ini saya krim ulang, minta bantu pak dan rekan2 Dear mas Wahyu, coba kirimkan ulang file lampirannya. 2016-01-08 21:08 GMT+07:00 'dwi' [email protected] [belajar-excel] <[email protected]>: dear all data terlampir ada data yang diinput manual semua (sheet tidak berwarna), minta tolong apakah bisa dibuatkan rumus sehingga kami hanya input data di sheet berwarna kuning tetapi data tertransfer otomatis ke sheet2 yg tidak berwarna dengan kreterian yang sudah kam inginkan mohon bantuannya sekian dan terima kasih regard dwi wahyu erwinsyah -----Original Message----- From: dwi [mailto:[email protected]] Sent: Friday, January 08, 2016 10:09 PM To: '[email protected]' Cc: '[email protected]' Subject: 150106 smd- Payment Control.xlsx dear all data terlampir ada data yang diinput manual semua (sheet tidak berwarna), minta tolong apakah bisa dibuatkan rumus sehingga kami hanya input data di sheet berwarna kuning tetapi data tertransfer otomatis ke sheet2 yg tidak berwarna dengan kreterian yang sudah kam inginkan mohon bantuannya sekian dan terima kasih regard dwi wahyu erwinsyah ----- No virus found in this message. Checked by AVG - www.avg.com Version: 2016.0.7294 / Virus Database: 4489/11373 - Release Date: 01/10/16 #yiv6759583786 #yiv6759583786 -- #yiv6759583786ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;} #yiv6759583786 #yiv6759583786ygrp-mkp hr { border:1px solid #d8d8d8;} #yiv6759583786 #yiv6759583786ygrp-mkp #yiv6759583786hd { color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;} #yiv6759583786 #yiv6759583786ygrp-mkp #yiv6759583786ads { margin-bottom:10px;} #yiv6759583786 #yiv6759583786ygrp-mkp .yiv6759583786ad { padding:0 0;} #yiv6759583786 #yiv6759583786ygrp-mkp .yiv6759583786ad p { margin:0;} #yiv6759583786 #yiv6759583786ygrp-mkp .yiv6759583786ad a { color:#0000ff;text-decoration:none;} #yiv6759583786 #yiv6759583786ygrp-sponsor #yiv6759583786ygrp-lc { font-family:Arial;} #yiv6759583786 #yiv6759583786ygrp-sponsor #yiv6759583786ygrp-lc #yiv6759583786hd { margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;} #yiv6759583786 #yiv6759583786ygrp-sponsor #yiv6759583786ygrp-lc .yiv6759583786ad { margin-bottom:10px;padding:0 0;} #yiv6759583786 #yiv6759583786actions { font-family:Verdana;font-size:11px;padding:10px 0;} #yiv6759583786 #yiv6759583786activity { background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;} #yiv6759583786 #yiv6759583786activity span { font-weight:700;} #yiv6759583786 #yiv6759583786activity span:first-child { text-transform:uppercase;} #yiv6759583786 #yiv6759583786activity span a { color:#5085b6;text-decoration:none;} #yiv6759583786 #yiv6759583786activity span span { color:#ff7900;} #yiv6759583786 #yiv6759583786activity span .yiv6759583786underline { text-decoration:underline;} #yiv6759583786 .yiv6759583786attach { clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;} #yiv6759583786 .yiv6759583786attach div a { text-decoration:none;} #yiv6759583786 .yiv6759583786attach img { border:none;padding-right:5px;} #yiv6759583786 .yiv6759583786attach label { display:block;margin-bottom:5px;} #yiv6759583786 .yiv6759583786attach label a { text-decoration:none;} #yiv6759583786 blockquote { margin:0 0 0 4px;} #yiv6759583786 .yiv6759583786bold { font-family:Arial;font-size:13px;font-weight:700;} #yiv6759583786 .yiv6759583786bold a { text-decoration:none;} #yiv6759583786 dd.yiv6759583786last p a { font-family:Verdana;font-weight:700;} #yiv6759583786 dd.yiv6759583786last p span { margin-right:10px;font-family:Verdana;font-weight:700;} #yiv6759583786 dd.yiv6759583786last p span.yiv6759583786yshortcuts { margin-right:0;} #yiv6759583786 div.yiv6759583786attach-table div div a { text-decoration:none;} #yiv6759583786 div.yiv6759583786attach-table { width:400px;} #yiv6759583786 div.yiv6759583786file-title a, #yiv6759583786 div.yiv6759583786file-title a:active, #yiv6759583786 div.yiv6759583786file-title a:hover, #yiv6759583786 div.yiv6759583786file-title a:visited { text-decoration:none;} #yiv6759583786 div.yiv6759583786photo-title a, #yiv6759583786 div.yiv6759583786photo-title a:active, #yiv6759583786 div.yiv6759583786photo-title a:hover, #yiv6759583786 div.yiv6759583786photo-title a:visited { text-decoration:none;} #yiv6759583786 div#yiv6759583786ygrp-mlmsg #yiv6759583786ygrp-msg p a span.yiv6759583786yshortcuts { font-family:Verdana;font-size:10px;font-weight:normal;} #yiv6759583786 .yiv6759583786green { color:#628c2a;} #yiv6759583786 .yiv6759583786MsoNormal { margin:0 0 0 0;} #yiv6759583786 o { font-size:0;} #yiv6759583786 #yiv6759583786photos div { float:left;width:72px;} #yiv6759583786 #yiv6759583786photos div div { border:1px solid #666666;height:62px;overflow:hidden;width:62px;} #yiv6759583786 #yiv6759583786photos div label { color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;} #yiv6759583786 #yiv6759583786reco-category { font-size:77%;} #yiv6759583786 #yiv6759583786reco-desc { font-size:77%;} #yiv6759583786 .yiv6759583786replbq { margin:4px;} #yiv6759583786 #yiv6759583786ygrp-actbar div a:first-child { margin-right:2px;padding-right:5px;} #yiv6759583786 #yiv6759583786ygrp-mlmsg { font-size:13px;font-family:Arial, helvetica, clean, sans-serif;} #yiv6759583786 #yiv6759583786ygrp-mlmsg table { font-size:inherit;font:100%;} #yiv6759583786 #yiv6759583786ygrp-mlmsg select, #yiv6759583786 input, #yiv6759583786 textarea { font:99% Arial, Helvetica, clean, sans-serif;} #yiv6759583786 #yiv6759583786ygrp-mlmsg pre, #yiv6759583786 code { font:115% monospace;} #yiv6759583786 #yiv6759583786ygrp-mlmsg * { line-height:1.22em;} #yiv6759583786 #yiv6759583786ygrp-mlmsg #yiv6759583786logo { padding-bottom:10px;} #yiv6759583786 #yiv6759583786ygrp-msg p a { font-family:Verdana;} #yiv6759583786 #yiv6759583786ygrp-msg p#yiv6759583786attach-count span { color:#1E66AE;font-weight:700;} #yiv6759583786 #yiv6759583786ygrp-reco #yiv6759583786reco-head { color:#ff7900;font-weight:700;} #yiv6759583786 #yiv6759583786ygrp-reco { margin-bottom:20px;padding:0px;} #yiv6759583786 #yiv6759583786ygrp-sponsor #yiv6759583786ov li a { font-size:130%;text-decoration:none;} #yiv6759583786 #yiv6759583786ygrp-sponsor #yiv6759583786ov li { font-size:77%;list-style-type:square;padding:6px 0;} #yiv6759583786 #yiv6759583786ygrp-sponsor #yiv6759583786ov ul { margin:0;padding:0 0 0 8px;} #yiv6759583786 #yiv6759583786ygrp-text { font-family:Georgia;} #yiv6759583786 #yiv6759583786ygrp-text p { margin:0 0 1em 0;} #yiv6759583786 #yiv6759583786ygrp-text tt { font-size:120%;} #yiv6759583786 #yiv6759583786ygrp-vital ul li:last-child { border-right:none !important; } #yiv6759583786
