Show original message On Monday, December 19, 2016 1:01 PM, kanadhasen Kana <[email protected]> wrote: Kepada mater excel, Mengingatkan kembali. Mohon Bantuannya dan urgent Terima Kasih Kana On Monday, December 19, 2016 7:25 AM, "kanadhasen Kana [email protected] [belajar-excel]" <[email protected]> wrote: Dear BeExceller, Mohon bantuannya, saya sedang membuat customer list, denga ini saya mengajukanpertanyaan ntuk metode yg digunakan tentang:1. Bagaimana cara mengelinkkan dari customer list ke 3 file (A,B,C) yang tersimpandalam folder dengan formula tanpa satu per satu karena jika customernya lebihdari 50 maka akan banyak membuang waktu kan?2. Bagaimana cara membuat hyperlink dari kolom namapelanggan tanpa satu persatu di customer list?3. Bagaimana cara membuat formula langsung di customer list dari nama pelanggan yangsudah menjadi hyperlink (Tersimpan dalam satu folder) yang berada di kolom B tanpasatu persatu sehingga terisi secara otomatis di kolom yang saya marking biru?Mohon maaf saya membutuhkan respon yang sangat cepat danurgent. Sekian pertanyaan saya, mohon maaf jika sulit utk dipahami, karena saya sendirihanya orang awam yg sedang belajar untuk mencoba sesuatu yg baru, mungkinattachment yg terlampir bisa sedikit membantu. Terima Kasih atas bantuannya. Salam, Kana #yiv4941185822 -- #yiv4941185822ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4941185822 #yiv4941185822ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4941185822 #yiv4941185822ygrp-mkp #yiv4941185822hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4941185822 #yiv4941185822ygrp-mkp #yiv4941185822ads {margin-bottom:10px;}#yiv4941185822 #yiv4941185822ygrp-mkp .yiv4941185822ad {padding:0 0;}#yiv4941185822 #yiv4941185822ygrp-mkp .yiv4941185822ad p {margin:0;}#yiv4941185822 #yiv4941185822ygrp-mkp .yiv4941185822ad a {color:#0000ff;text-decoration:none;}#yiv4941185822 #yiv4941185822ygrp-sponsor #yiv4941185822ygrp-lc {font-family:Arial;}#yiv4941185822 #yiv4941185822ygrp-sponsor #yiv4941185822ygrp-lc #yiv4941185822hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4941185822 #yiv4941185822ygrp-sponsor #yiv4941185822ygrp-lc .yiv4941185822ad {margin-bottom:10px;padding:0 0;}#yiv4941185822 #yiv4941185822actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4941185822 #yiv4941185822activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4941185822 #yiv4941185822activity span {font-weight:700;}#yiv4941185822 #yiv4941185822activity span:first-child {text-transform:uppercase;}#yiv4941185822 #yiv4941185822activity span a {color:#5085b6;text-decoration:none;}#yiv4941185822 #yiv4941185822activity span span {color:#ff7900;}#yiv4941185822 #yiv4941185822activity span .yiv4941185822underline {text-decoration:underline;}#yiv4941185822 .yiv4941185822attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4941185822 .yiv4941185822attach div a {text-decoration:none;}#yiv4941185822 .yiv4941185822attach img {border:none;padding-right:5px;}#yiv4941185822 .yiv4941185822attach label {display:block;margin-bottom:5px;}#yiv4941185822 .yiv4941185822attach label a {text-decoration:none;}#yiv4941185822 blockquote {margin:0 0 0 4px;}#yiv4941185822 .yiv4941185822bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4941185822 .yiv4941185822bold a {text-decoration:none;}#yiv4941185822 dd.yiv4941185822last p a {font-family:Verdana;font-weight:700;}#yiv4941185822 dd.yiv4941185822last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4941185822 dd.yiv4941185822last p span.yiv4941185822yshortcuts {margin-right:0;}#yiv4941185822 div.yiv4941185822attach-table div div a {text-decoration:none;}#yiv4941185822 div.yiv4941185822attach-table {width:400px;}#yiv4941185822 div.yiv4941185822file-title a, #yiv4941185822 div.yiv4941185822file-title a:active, #yiv4941185822 div.yiv4941185822file-title a:hover, #yiv4941185822 div.yiv4941185822file-title a:visited {text-decoration:none;}#yiv4941185822 div.yiv4941185822photo-title a, #yiv4941185822 div.yiv4941185822photo-title a:active, #yiv4941185822 div.yiv4941185822photo-title a:hover, #yiv4941185822 div.yiv4941185822photo-title a:visited {text-decoration:none;}#yiv4941185822 div#yiv4941185822ygrp-mlmsg #yiv4941185822ygrp-msg p a span.yiv4941185822yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4941185822 .yiv4941185822green {color:#628c2a;}#yiv4941185822 .yiv4941185822MsoNormal {margin:0 0 0 0;}#yiv4941185822 o {font-size:0;}#yiv4941185822 #yiv4941185822photos div {float:left;width:72px;}#yiv4941185822 #yiv4941185822photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv4941185822 #yiv4941185822photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4941185822 #yiv4941185822reco-category {font-size:77%;}#yiv4941185822 #yiv4941185822reco-desc {font-size:77%;}#yiv4941185822 .yiv4941185822replbq {margin:4px;}#yiv4941185822 #yiv4941185822ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4941185822 #yiv4941185822ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4941185822 #yiv4941185822ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4941185822 #yiv4941185822ygrp-mlmsg select, #yiv4941185822 input, #yiv4941185822 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4941185822 #yiv4941185822ygrp-mlmsg pre, #yiv4941185822 code {font:115% monospace;}#yiv4941185822 #yiv4941185822ygrp-mlmsg * {line-height:1.22em;}#yiv4941185822 #yiv4941185822ygrp-mlmsg #yiv4941185822logo {padding-bottom:10px;}#yiv4941185822 #yiv4941185822ygrp-msg p a {font-family:Verdana;}#yiv4941185822 #yiv4941185822ygrp-msg p#yiv4941185822attach-count span {color:#1E66AE;font-weight:700;}#yiv4941185822 #yiv4941185822ygrp-reco #yiv4941185822reco-head {color:#ff7900;font-weight:700;}#yiv4941185822 #yiv4941185822ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4941185822 #yiv4941185822ygrp-sponsor #yiv4941185822ov li a {font-size:130%;text-decoration:none;}#yiv4941185822 #yiv4941185822ygrp-sponsor #yiv4941185822ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4941185822 #yiv4941185822ygrp-sponsor #yiv4941185822ov ul {margin:0;padding:0 0 0 8px;}#yiv4941185822 #yiv4941185822ygrp-text {font-family:Georgia;}#yiv4941185822 #yiv4941185822ygrp-text p {margin:0 0 1em 0;}#yiv4941185822 #yiv4941185822ygrp-text tt {font-size:120%;}#yiv4941185822 #yiv4941185822ygrp-vital ul li:last-child {border-right:none !important;}#yiv4941185822
CUSTOMER LIST.xlsx
Description: MS-Excel 2007 spreadsheet
C.xlsx
Description: MS-Excel 2007 spreadsheet
B.xlsx
Description: MS-Excel 2007 spreadsheet
A.xlsx
Description: MS-Excel 2007 spreadsheet
