Dear Kamirin,Setahu saya, file 1 harus dibuka dulu...setelah file 2 dibuka baru
file 1 ditutup lagi.Ini bisa pakai macro auto open.
Salam,HK
Sent from Yahoo Mail on Android
On Sat, Sep 21, 2019 at 8:46, Kamirin Faqoth kamiri...@yahoo.co.id
[belajar-excel] wrote:
Dear All Member Be-Excel,
Bagaimana cara kerja Vlookup antar file, misal saya mempunya 2 file,
File 1 Sumber datanyaFile 2 Hasil datanya berupa rumus-rumus vlookup dll
Jika saya mengupdate data di File 1 dan klik save setelah selesai lalu close,
tanpa saya harus membuka file 2, apakah nanti ketika saya buka file 2, sudah
otomatis berubah? atau ada settingan khusus, soalnya td saya mencoba pas buka
File 2, harus sy klik 2 kali pada salah satu cell, baru berubah angkanya.
Terima Kasih atas Pencerahan,
salam,Kamirin
#yiv7492027584 #yiv7492027584 -- #yiv7492027584ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7492027584
#yiv7492027584ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7492027584
#yiv7492027584ygrp-mkp #yiv7492027584hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7492027584 #yiv7492027584ygrp-mkp #yiv7492027584ads
{margin-bottom:10px;}#yiv7492027584 #yiv7492027584ygrp-mkp .yiv7492027584ad
{padding:0 0;}#yiv7492027584 #yiv7492027584ygrp-mkp .yiv7492027584ad p
{margin:0;}#yiv7492027584 #yiv7492027584ygrp-mkp .yiv7492027584ad a
{color:#ff;text-decoration:none;}#yiv7492027584 #yiv7492027584ygrp-sponsor
#yiv7492027584ygrp-lc {font-family:Arial;}#yiv7492027584
#yiv7492027584ygrp-sponsor #yiv7492027584ygrp-lc #yiv7492027584hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7492027584
#yiv7492027584ygrp-sponsor #yiv7492027584ygrp-lc .yiv7492027584ad
{margin-bottom:10px;padding:0 0;}#yiv7492027584 #yiv7492027584actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7492027584
#yiv7492027584activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7492027584
#yiv7492027584activity span {font-weight:700;}#yiv7492027584
#yiv7492027584activity span:first-child
{text-transform:uppercase;}#yiv7492027584 #yiv7492027584activity span a
{color:#5085b6;text-decoration:none;}#yiv7492027584 #yiv7492027584activity span
span {color:#ff7900;}#yiv7492027584 #yiv7492027584activity span
.yiv7492027584underline {text-decoration:underline;}#yiv7492027584
.yiv7492027584attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7492027584 .yiv7492027584attach div a
{text-decoration:none;}#yiv7492027584 .yiv7492027584attach img
{border:none;padding-right:5px;}#yiv7492027584 .yiv7492027584attach label
{display:block;margin-bottom:5px;}#yiv7492027584 .yiv7492027584attach label a
{text-decoration:none;}#yiv7492027584 blockquote {margin:0 0 0
4px;}#yiv7492027584 .yiv7492027584bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7492027584
.yiv7492027584bold a {text-decoration:none;}#yiv7492027584 dd.yiv7492027584last
p a {font-family:Verdana;font-weight:700;}#yiv7492027584 dd.yiv7492027584last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7492027584
dd.yiv7492027584last p span.yiv7492027584yshortcuts
{margin-right:0;}#yiv7492027584 div.yiv7492027584attach-table div div a
{text-decoration:none;}#yiv7492027584 div.yiv7492027584attach-table
{width:400px;}#yiv7492027584 div.yiv7492027584file-title a, #yiv7492027584
div.yiv7492027584file-title a:active, #yiv7492027584
div.yiv7492027584file-title a:hover, #yiv7492027584 div.yiv7492027584file-title
a:visited {text-decoration:none;}#yiv7492027584 div.yiv7492027584photo-title a,
#yiv7492027584 div.yiv7492027584photo-title a:active, #yiv7492027584
div.yiv7492027584photo-title a:hover, #yiv7492027584
div.yiv7492027584photo-title a:visited {text-decoration:none;}#yiv7492027584
div#yiv7492027584ygrp-mlmsg #yiv7492027584ygrp-msg p a
span.yiv7492027584yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7492027584
.yiv7492027584green {color:#628c2a;}#yiv7492027584 .yiv7492027584MsoNormal
{margin:0 0 0 0;}#yiv7492027584 o {font-size:0;}#yiv7492027584
#yiv7492027584photos div {float:left;width:72px;}#yiv7492027584
#yiv7492027584photos div div {border:1px solid
#66;min-height:62px;overflow:hidden;width:62px;}#yiv7492027584
#yiv7492027584photos div label
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7492027584
#yiv7492027584reco-category {font-size:77%;}#yiv7492027584
#yiv7492027584reco-desc {font-size:77%;}#yiv7492027584 .yiv7492027584replbq
{margin:4px;}#yiv7492027584 #yiv7492027584ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7492027584 #yiv7492027584ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7492027584
#yiv7492027584ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7492027584
#yiv7492027584ygrp-mlmsg select,