sekedar mengingatkan saja...setiap pertanyaan yang sulit di mengerti dan
banyak, biasanya member hanya melihat dan mengabaikannya...menunggu siapa yang
mau jawab...
mungkin klo pertanyaanya di permudah, contohnya di perjelas, pertanyaannya ga
borongan dan menanyakan dengan lebih santun, bisa jadi tar banyak yang jawab...
terusterang aja sih, kalo saya ga bisa jawabnya...
tp klo yang lain pasti ada yang bisa, hanya saja lagi sungkan saja mungkin
melihat email ini dan berfikir ah nanti juga ada yang jawab...
hehehe.... br,
odong nando
Dari: "kanadhasen Kana kanadhasen...@yahoo.com [belajar-excel]"
<belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Rabu, 21 Desember 2016 10:48
Judul: Fw: [belajar-excel] Ngelink data dengan formula [4 Attachments]
Show original message On Tuesday, December 20, 2016 8:38 AM, kanadhasen
Kana <kanadhasen...@yahoo.com> wrote:
Kepada mater excel,
Mengingatkan kembali. Mohon Bantuannya banget dan urgent
Terima Kasih
Kana
Show original message On Monday, December 19, 2016 1:01 PM, kanadhasen
Kana <kanadhasen...@yahoo.com> wrote:
Kepada mater excel,
Mengingatkan kembali. Mohon Bantuannya dan urgent
Terima Kasih
Kana
On Monday, December 19, 2016 7:25 AM, "kanadhasen Kana
kanadhasen...@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> 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
#yiv9804373442 #yiv9804373442 -- #yiv9804373442ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9804373442
#yiv9804373442ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9804373442
#yiv9804373442ygrp-mkp #yiv9804373442hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9804373442 #yiv9804373442ygrp-mkp #yiv9804373442ads
{margin-bottom:10px;}#yiv9804373442 #yiv9804373442ygrp-mkp .yiv9804373442ad
{padding:0 0;}#yiv9804373442 #yiv9804373442ygrp-mkp .yiv9804373442ad p
{margin:0;}#yiv9804373442 #yiv9804373442ygrp-mkp .yiv9804373442ad a
{color:#0000ff;text-decoration:none;}#yiv9804373442 #yiv9804373442ygrp-sponsor
#yiv9804373442ygrp-lc {font-family:Arial;}#yiv9804373442
#yiv9804373442ygrp-sponsor #yiv9804373442ygrp-lc #yiv9804373442hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9804373442
#yiv9804373442ygrp-sponsor #yiv9804373442ygrp-lc .yiv9804373442ad
{margin-bottom:10px;padding:0 0;}#yiv9804373442 #yiv9804373442actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9804373442
#yiv9804373442activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9804373442
#yiv9804373442activity span {font-weight:700;}#yiv9804373442
#yiv9804373442activity span:first-child
{text-transform:uppercase;}#yiv9804373442 #yiv9804373442activity span a
{color:#5085b6;text-decoration:none;}#yiv9804373442 #yiv9804373442activity span
span {color:#ff7900;}#yiv9804373442 #yiv9804373442activity span
.yiv9804373442underline {text-decoration:underline;}#yiv9804373442
.yiv9804373442attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9804373442 .yiv9804373442attach div a
{text-decoration:none;}#yiv9804373442 .yiv9804373442attach img
{border:none;padding-right:5px;}#yiv9804373442 .yiv9804373442attach label
{display:block;margin-bottom:5px;}#yiv9804373442 .yiv9804373442attach label a
{text-decoration:none;}#yiv9804373442 blockquote {margin:0 0 0
4px;}#yiv9804373442 .yiv9804373442bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9804373442
.yiv9804373442bold a {text-decoration:none;}#yiv9804373442 dd.yiv9804373442last
p a {font-family:Verdana;font-weight:700;}#yiv9804373442 dd.yiv9804373442last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9804373442
dd.yiv9804373442last p span.yiv9804373442yshortcuts
{margin-right:0;}#yiv9804373442 div.yiv9804373442attach-table div div a
{text-decoration:none;}#yiv9804373442 div.yiv9804373442attach-table
{width:400px;}#yiv9804373442 div.yiv9804373442file-title a, #yiv9804373442
div.yiv9804373442file-title a:active, #yiv9804373442
div.yiv9804373442file-title a:hover, #yiv9804373442 div.yiv9804373442file-title
a:visited {text-decoration:none;}#yiv9804373442 div.yiv9804373442photo-title a,
#yiv9804373442 div.yiv9804373442photo-title a:active, #yiv9804373442
div.yiv9804373442photo-title a:hover, #yiv9804373442
div.yiv9804373442photo-title a:visited {text-decoration:none;}#yiv9804373442
div#yiv9804373442ygrp-mlmsg #yiv9804373442ygrp-msg p a
span.yiv9804373442yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9804373442
.yiv9804373442green {color:#628c2a;}#yiv9804373442 .yiv9804373442MsoNormal
{margin:0 0 0 0;}#yiv9804373442 o {font-size:0;}#yiv9804373442
#yiv9804373442photos div {float:left;width:72px;}#yiv9804373442
#yiv9804373442photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv9804373442
#yiv9804373442photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9804373442
#yiv9804373442reco-category {font-size:77%;}#yiv9804373442
#yiv9804373442reco-desc {font-size:77%;}#yiv9804373442 .yiv9804373442replbq
{margin:4px;}#yiv9804373442 #yiv9804373442ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9804373442 #yiv9804373442ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9804373442
#yiv9804373442ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9804373442
#yiv9804373442ygrp-mlmsg select, #yiv9804373442 input, #yiv9804373442 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9804373442
#yiv9804373442ygrp-mlmsg pre, #yiv9804373442 code {font:115%
monospace;}#yiv9804373442 #yiv9804373442ygrp-mlmsg *
{line-height:1.22em;}#yiv9804373442 #yiv9804373442ygrp-mlmsg #yiv9804373442logo
{padding-bottom:10px;}#yiv9804373442 #yiv9804373442ygrp-msg p a
{font-family:Verdana;}#yiv9804373442 #yiv9804373442ygrp-msg
p#yiv9804373442attach-count span {color:#1E66AE;font-weight:700;}#yiv9804373442
#yiv9804373442ygrp-reco #yiv9804373442reco-head
{color:#ff7900;font-weight:700;}#yiv9804373442 #yiv9804373442ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9804373442 #yiv9804373442ygrp-sponsor
#yiv9804373442ov li a {font-size:130%;text-decoration:none;}#yiv9804373442
#yiv9804373442ygrp-sponsor #yiv9804373442ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9804373442
#yiv9804373442ygrp-sponsor #yiv9804373442ov ul {margin:0;padding:0 0 0
8px;}#yiv9804373442 #yiv9804373442ygrp-text
{font-family:Georgia;}#yiv9804373442 #yiv9804373442ygrp-text p {margin:0 0 1em
0;}#yiv9804373442 #yiv9804373442ygrp-text tt {font-size:120%;}#yiv9804373442
#yiv9804373442ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9804373442
