nah.. seperti itu yg ada di kepala saya gan.. masalahnya.. saya tidak tahu membuat yg seperti itu.. (maaf)sekiranya suhu berkenan memberikan penerapannya pada file terlampir sebelumnya (file terlampir "real converting)
Pada Kamis, 27 November 2014 2:28, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> menulis:
Letakkan saja tabel referensi nya pada sebuah sheet tersendiri. Formula
merujuk ke sheet khusus tersebut. Sheet khusus tersebut di-hide. Akhirnya, jadi
seperti tabel referensi yang disimpan di kepala bukan ? Sama-sama ndak
kelihatan tapi ada.
Wassalam,
Kid.
2014-11-27 3:57 GMT+11:00 [email protected] [belajar-excel]
<[email protected]>:
terimakasih atas respon nya Suhu Mr.kidmaksut saya begini, ketentuan nilai
dan konversinya kita simpan di kepala.. (ketentuan konversi tadi tidak
disertakan dalam lembar kerja)
file terlampir,regards.
#yiv4562941967 #yiv4562941967 -- #yiv4562941967ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4562941967
#yiv4562941967ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4562941967
#yiv4562941967ygrp-mkp #yiv4562941967hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4562941967 #yiv4562941967ygrp-mkp #yiv4562941967ads
{margin-bottom:10px;}#yiv4562941967 #yiv4562941967ygrp-mkp .yiv4562941967ad
{padding:0 0;}#yiv4562941967 #yiv4562941967ygrp-mkp .yiv4562941967ad p
{margin:0;}#yiv4562941967 #yiv4562941967ygrp-mkp .yiv4562941967ad a
{color:#0000ff;text-decoration:none;}#yiv4562941967 #yiv4562941967ygrp-sponsor
#yiv4562941967ygrp-lc {font-family:Arial;}#yiv4562941967
#yiv4562941967ygrp-sponsor #yiv4562941967ygrp-lc #yiv4562941967hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4562941967
#yiv4562941967ygrp-sponsor #yiv4562941967ygrp-lc .yiv4562941967ad
{margin-bottom:10px;padding:0 0;}#yiv4562941967 #yiv4562941967actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4562941967
#yiv4562941967activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4562941967
#yiv4562941967activity span {font-weight:700;}#yiv4562941967
#yiv4562941967activity span:first-child
{text-transform:uppercase;}#yiv4562941967 #yiv4562941967activity span a
{color:#5085b6;text-decoration:none;}#yiv4562941967 #yiv4562941967activity span
span {color:#ff7900;}#yiv4562941967 #yiv4562941967activity span
.yiv4562941967underline {text-decoration:underline;}#yiv4562941967
.yiv4562941967attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4562941967 .yiv4562941967attach div a
{text-decoration:none;}#yiv4562941967 .yiv4562941967attach img
{border:none;padding-right:5px;}#yiv4562941967 .yiv4562941967attach label
{display:block;margin-bottom:5px;}#yiv4562941967 .yiv4562941967attach label a
{text-decoration:none;}#yiv4562941967 blockquote {margin:0 0 0
4px;}#yiv4562941967 .yiv4562941967bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4562941967
.yiv4562941967bold a {text-decoration:none;}#yiv4562941967 dd.yiv4562941967last
p a {font-family:Verdana;font-weight:700;}#yiv4562941967 dd.yiv4562941967last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4562941967
dd.yiv4562941967last p span.yiv4562941967yshortcuts
{margin-right:0;}#yiv4562941967 div.yiv4562941967attach-table div div a
{text-decoration:none;}#yiv4562941967 div.yiv4562941967attach-table
{width:400px;}#yiv4562941967 div.yiv4562941967file-title a, #yiv4562941967
div.yiv4562941967file-title a:active, #yiv4562941967
div.yiv4562941967file-title a:hover, #yiv4562941967 div.yiv4562941967file-title
a:visited {text-decoration:none;}#yiv4562941967 div.yiv4562941967photo-title a,
#yiv4562941967 div.yiv4562941967photo-title a:active, #yiv4562941967
div.yiv4562941967photo-title a:hover, #yiv4562941967
div.yiv4562941967photo-title a:visited {text-decoration:none;}#yiv4562941967
div#yiv4562941967ygrp-mlmsg #yiv4562941967ygrp-msg p a
span.yiv4562941967yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4562941967
.yiv4562941967green {color:#628c2a;}#yiv4562941967 .yiv4562941967MsoNormal
{margin:0 0 0 0;}#yiv4562941967 o {font-size:0;}#yiv4562941967
#yiv4562941967photos div {float:left;width:72px;}#yiv4562941967
#yiv4562941967photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv4562941967
#yiv4562941967photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4562941967
#yiv4562941967reco-category {font-size:77%;}#yiv4562941967
#yiv4562941967reco-desc {font-size:77%;}#yiv4562941967 .yiv4562941967replbq
{margin:4px;}#yiv4562941967 #yiv4562941967ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4562941967 #yiv4562941967ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4562941967
#yiv4562941967ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4562941967
#yiv4562941967ygrp-mlmsg select, #yiv4562941967 input, #yiv4562941967 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4562941967
#yiv4562941967ygrp-mlmsg pre, #yiv4562941967 code {font:115%
monospace;}#yiv4562941967 #yiv4562941967ygrp-mlmsg *
{line-height:1.22em;}#yiv4562941967 #yiv4562941967ygrp-mlmsg #yiv4562941967logo
{padding-bottom:10px;}#yiv4562941967 #yiv4562941967ygrp-msg p a
{font-family:Verdana;}#yiv4562941967 #yiv4562941967ygrp-msg
p#yiv4562941967attach-count span {color:#1E66AE;font-weight:700;}#yiv4562941967
#yiv4562941967ygrp-reco #yiv4562941967reco-head
{color:#ff7900;font-weight:700;}#yiv4562941967 #yiv4562941967ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4562941967 #yiv4562941967ygrp-sponsor
#yiv4562941967ov li a {font-size:130%;text-decoration:none;}#yiv4562941967
#yiv4562941967ygrp-sponsor #yiv4562941967ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4562941967
#yiv4562941967ygrp-sponsor #yiv4562941967ov ul {margin:0;padding:0 0 0
8px;}#yiv4562941967 #yiv4562941967ygrp-text
{font-family:Georgia;}#yiv4562941967 #yiv4562941967ygrp-text p {margin:0 0 1em
0;}#yiv4562941967 #yiv4562941967ygrp-text tt {font-size:120%;}#yiv4562941967
#yiv4562941967ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4562941967
real converting.xlsx
Description: MS-Excel 2007 spreadsheet
