Dear BeExceller, Mohon bantuannya dengan sangat ada yang membantu saya dari permasalahan excel yang saya hadapin.
Terima Kasih
Salam,
Kana
On Wednesday, January 4, 2017 7:31 AM, "kanadhasen Kana
[email protected] [belajar-excel]" <[email protected]> wrote:
Show original message On Tuesday, December 20, 2016 8:38 AM, kanadhasen
Kana <[email protected]> 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 <[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
#yiv3172958985 #yiv3172958985 -- #yiv3172958985ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3172958985
#yiv3172958985ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3172958985
#yiv3172958985ygrp-mkp #yiv3172958985hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv3172958985 #yiv3172958985ygrp-mkp #yiv3172958985ads
{margin-bottom:10px;}#yiv3172958985 #yiv3172958985ygrp-mkp .yiv3172958985ad
{padding:0 0;}#yiv3172958985 #yiv3172958985ygrp-mkp .yiv3172958985ad p
{margin:0;}#yiv3172958985 #yiv3172958985ygrp-mkp .yiv3172958985ad a
{color:#0000ff;text-decoration:none;}#yiv3172958985 #yiv3172958985ygrp-sponsor
#yiv3172958985ygrp-lc {font-family:Arial;}#yiv3172958985
#yiv3172958985ygrp-sponsor #yiv3172958985ygrp-lc #yiv3172958985hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3172958985
#yiv3172958985ygrp-sponsor #yiv3172958985ygrp-lc .yiv3172958985ad
{margin-bottom:10px;padding:0 0;}#yiv3172958985 #yiv3172958985actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3172958985
#yiv3172958985activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3172958985
#yiv3172958985activity span {font-weight:700;}#yiv3172958985
#yiv3172958985activity span:first-child
{text-transform:uppercase;}#yiv3172958985 #yiv3172958985activity span a
{color:#5085b6;text-decoration:none;}#yiv3172958985 #yiv3172958985activity span
span {color:#ff7900;}#yiv3172958985 #yiv3172958985activity span
.yiv3172958985underline {text-decoration:underline;}#yiv3172958985
.yiv3172958985attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv3172958985 .yiv3172958985attach div a
{text-decoration:none;}#yiv3172958985 .yiv3172958985attach img
{border:none;padding-right:5px;}#yiv3172958985 .yiv3172958985attach label
{display:block;margin-bottom:5px;}#yiv3172958985 .yiv3172958985attach label a
{text-decoration:none;}#yiv3172958985 blockquote {margin:0 0 0
4px;}#yiv3172958985 .yiv3172958985bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3172958985
.yiv3172958985bold a {text-decoration:none;}#yiv3172958985 dd.yiv3172958985last
p a {font-family:Verdana;font-weight:700;}#yiv3172958985 dd.yiv3172958985last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3172958985
dd.yiv3172958985last p span.yiv3172958985yshortcuts
{margin-right:0;}#yiv3172958985 div.yiv3172958985attach-table div div a
{text-decoration:none;}#yiv3172958985 div.yiv3172958985attach-table
{width:400px;}#yiv3172958985 div.yiv3172958985file-title a, #yiv3172958985
div.yiv3172958985file-title a:active, #yiv3172958985
div.yiv3172958985file-title a:hover, #yiv3172958985 div.yiv3172958985file-title
a:visited {text-decoration:none;}#yiv3172958985 div.yiv3172958985photo-title a,
#yiv3172958985 div.yiv3172958985photo-title a:active, #yiv3172958985
div.yiv3172958985photo-title a:hover, #yiv3172958985
div.yiv3172958985photo-title a:visited {text-decoration:none;}#yiv3172958985
div#yiv3172958985ygrp-mlmsg #yiv3172958985ygrp-msg p a
span.yiv3172958985yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3172958985
.yiv3172958985green {color:#628c2a;}#yiv3172958985 .yiv3172958985MsoNormal
{margin:0 0 0 0;}#yiv3172958985 o {font-size:0;}#yiv3172958985
#yiv3172958985photos div {float:left;width:72px;}#yiv3172958985
#yiv3172958985photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv3172958985
#yiv3172958985photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3172958985
#yiv3172958985reco-category {font-size:77%;}#yiv3172958985
#yiv3172958985reco-desc {font-size:77%;}#yiv3172958985 .yiv3172958985replbq
{margin:4px;}#yiv3172958985 #yiv3172958985ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv3172958985 #yiv3172958985ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3172958985
#yiv3172958985ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3172958985
#yiv3172958985ygrp-mlmsg select, #yiv3172958985 input, #yiv3172958985 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3172958985
#yiv3172958985ygrp-mlmsg pre, #yiv3172958985 code {font:115%
monospace;}#yiv3172958985 #yiv3172958985ygrp-mlmsg *
{line-height:1.22em;}#yiv3172958985 #yiv3172958985ygrp-mlmsg #yiv3172958985logo
{padding-bottom:10px;}#yiv3172958985 #yiv3172958985ygrp-msg p a
{font-family:Verdana;}#yiv3172958985 #yiv3172958985ygrp-msg
p#yiv3172958985attach-count span {color:#1E66AE;font-weight:700;}#yiv3172958985
#yiv3172958985ygrp-reco #yiv3172958985reco-head
{color:#ff7900;font-weight:700;}#yiv3172958985 #yiv3172958985ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv3172958985 #yiv3172958985ygrp-sponsor
#yiv3172958985ov li a {font-size:130%;text-decoration:none;}#yiv3172958985
#yiv3172958985ygrp-sponsor #yiv3172958985ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv3172958985
#yiv3172958985ygrp-sponsor #yiv3172958985ov ul {margin:0;padding:0 0 0
8px;}#yiv3172958985 #yiv3172958985ygrp-text
{font-family:Georgia;}#yiv3172958985 #yiv3172958985ygrp-text p {margin:0 0 1em
0;}#yiv3172958985 #yiv3172958985ygrp-text tt {font-size:120%;}#yiv3172958985
#yiv3172958985ygrp-vital ul li:last-child {border-right:none
!important;}#yiv3172958985
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
