dah..dicoba berhasil.. maksih.. Mr Kid, namun yang saya inginkan itu.. setiap perubahan nilai a1 atau b1 hasil perkaliannya. berubah juga. di sheet2.. tolong pencerahannya.. makasih, roy
Pada Minggu, 31 Januari 2016 20:19, "'Mr. Kid' mr.nm...@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis: Hai Roy, Dengan deskripsi yang Anda buat, coba langkah berikut : 1. klik sheet2 -> klik cells G1 2. ketik karakter = (sama dengan) -> klik nama sheet1 -> klik cells a1 -> ketik karakter * (asterix) -> klik cells B1 -> tekan ENTER 3. klik G1 -> tekan CTRL C -> blok G1:G5 -> tekan CTRL V Semoga sukses. Regards, Kid 2016-01-31 19:31 GMT+07:00 roy sumarna rohendi_2...@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com>: dear excelersudah lama saya tidak bertanya.. dan hanya menyimak saja.. karena banyak. yang tidak mengerti..saya ada persoalan bagaimana rumus penjumlahan otomatis tapi hasilnya adapada sheet lain.. contoh saya ada pada sheet 2makasih bantuannya.. rohaendi #yiv3545034497 #yiv3545034497 -- #yiv3545034497ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3545034497 #yiv3545034497ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3545034497 #yiv3545034497ygrp-mkp #yiv3545034497hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3545034497 #yiv3545034497ygrp-mkp #yiv3545034497ads {margin-bottom:10px;}#yiv3545034497 #yiv3545034497ygrp-mkp .yiv3545034497ad {padding:0 0;}#yiv3545034497 #yiv3545034497ygrp-mkp .yiv3545034497ad p {margin:0;}#yiv3545034497 #yiv3545034497ygrp-mkp .yiv3545034497ad a {color:#0000ff;text-decoration:none;}#yiv3545034497 #yiv3545034497ygrp-sponsor #yiv3545034497ygrp-lc {font-family:Arial;}#yiv3545034497 #yiv3545034497ygrp-sponsor #yiv3545034497ygrp-lc #yiv3545034497hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3545034497 #yiv3545034497ygrp-sponsor #yiv3545034497ygrp-lc .yiv3545034497ad {margin-bottom:10px;padding:0 0;}#yiv3545034497 #yiv3545034497actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3545034497 #yiv3545034497activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3545034497 #yiv3545034497activity span {font-weight:700;}#yiv3545034497 #yiv3545034497activity span:first-child {text-transform:uppercase;}#yiv3545034497 #yiv3545034497activity span a {color:#5085b6;text-decoration:none;}#yiv3545034497 #yiv3545034497activity span span {color:#ff7900;}#yiv3545034497 #yiv3545034497activity span .yiv3545034497underline {text-decoration:underline;}#yiv3545034497 .yiv3545034497attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3545034497 .yiv3545034497attach div a {text-decoration:none;}#yiv3545034497 .yiv3545034497attach img {border:none;padding-right:5px;}#yiv3545034497 .yiv3545034497attach label {display:block;margin-bottom:5px;}#yiv3545034497 .yiv3545034497attach label a {text-decoration:none;}#yiv3545034497 blockquote {margin:0 0 0 4px;}#yiv3545034497 .yiv3545034497bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3545034497 .yiv3545034497bold a {text-decoration:none;}#yiv3545034497 dd.yiv3545034497last p a {font-family:Verdana;font-weight:700;}#yiv3545034497 dd.yiv3545034497last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3545034497 dd.yiv3545034497last p span.yiv3545034497yshortcuts {margin-right:0;}#yiv3545034497 div.yiv3545034497attach-table div div a {text-decoration:none;}#yiv3545034497 div.yiv3545034497attach-table {width:400px;}#yiv3545034497 div.yiv3545034497file-title a, #yiv3545034497 div.yiv3545034497file-title a:active, #yiv3545034497 div.yiv3545034497file-title a:hover, #yiv3545034497 div.yiv3545034497file-title a:visited {text-decoration:none;}#yiv3545034497 div.yiv3545034497photo-title a, #yiv3545034497 div.yiv3545034497photo-title a:active, #yiv3545034497 div.yiv3545034497photo-title a:hover, #yiv3545034497 div.yiv3545034497photo-title a:visited {text-decoration:none;}#yiv3545034497 div#yiv3545034497ygrp-mlmsg #yiv3545034497ygrp-msg p a span.yiv3545034497yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3545034497 .yiv3545034497green {color:#628c2a;}#yiv3545034497 .yiv3545034497MsoNormal {margin:0 0 0 0;}#yiv3545034497 o {font-size:0;}#yiv3545034497 #yiv3545034497photos div {float:left;width:72px;}#yiv3545034497 #yiv3545034497photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3545034497 #yiv3545034497photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3545034497 #yiv3545034497reco-category {font-size:77%;}#yiv3545034497 #yiv3545034497reco-desc {font-size:77%;}#yiv3545034497 .yiv3545034497replbq {margin:4px;}#yiv3545034497 #yiv3545034497ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3545034497 #yiv3545034497ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3545034497 #yiv3545034497ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3545034497 #yiv3545034497ygrp-mlmsg select, #yiv3545034497 input, #yiv3545034497 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3545034497 #yiv3545034497ygrp-mlmsg pre, #yiv3545034497 code {font:115% monospace;}#yiv3545034497 #yiv3545034497ygrp-mlmsg * {line-height:1.22em;}#yiv3545034497 #yiv3545034497ygrp-mlmsg #yiv3545034497logo {padding-bottom:10px;}#yiv3545034497 #yiv3545034497ygrp-msg p a {font-family:Verdana;}#yiv3545034497 #yiv3545034497ygrp-msg p#yiv3545034497attach-count span {color:#1E66AE;font-weight:700;}#yiv3545034497 #yiv3545034497ygrp-reco #yiv3545034497reco-head {color:#ff7900;font-weight:700;}#yiv3545034497 #yiv3545034497ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3545034497 #yiv3545034497ygrp-sponsor #yiv3545034497ov li a {font-size:130%;text-decoration:none;}#yiv3545034497 #yiv3545034497ygrp-sponsor #yiv3545034497ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3545034497 #yiv3545034497ygrp-sponsor #yiv3545034497ov ul {margin:0;padding:0 0 0 8px;}#yiv3545034497 #yiv3545034497ygrp-text {font-family:Georgia;}#yiv3545034497 #yiv3545034497ygrp-text p {margin:0 0 1em 0;}#yiv3545034497 #yiv3545034497ygrp-text tt {font-size:120%;}#yiv3545034497 #yiv3545034497ygrp-vital ul li:last-child {border-right:none !important;}#yiv3545034497