Hai Heru,Saya coba jawab ya, mudah2 an betul (sesuai dengan keinginan).
1. Jika hasilnya N/A maka coba perhatikan penulisan formula
.......ROW(baris_awal:baris_akhir)2. Coba ganti Regional format anda dengan
English (US)
Salam,HK
From: "heru Rasna herura...@yahoo.co.id [belajar-excel]"
<belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Sunday, 30 April 2017, 17:27
Subject: [belajar-excel] Help [ Data dihapus rumus berubah ] [1 Attachment]
Salam Kenal
mohon pencerahannya master, saya sedang belajar mengerjakan form perjalanan
dinas dan surat perintah perjalanan dengan meng adopt dari file
ctv_simpleInvoicingSystem_NewV2 warisan dari almr. SITI_VI, di dalam file yang
saya buat ada dua data base ( sheetdbase1 dan dbase2), nah yang jadi kendala
pada saat saya hapus data pada sheet dbase1 dan dbase2 (hasil record dari form
input) rumus pada sheet SPT ( untuk privew sekaligus menu cetak) berubah, hasil
N/A. lalu pada forminput utuk tanggal saya menggunakan DTPICKER yang terhubung
ke cell, format pada DTPICKER menggunakan format Long Date (co/ 1 April 2017) ,
namun pada cell link nya output formatnya menjadi shortdate (co/ 01/04/2017)
sehingga pada saat disimpan di data base sheet dbase1 maupun dbase2 formatnya
tetap sama dan tidak bisa dirubah. Udah saya itak atok di propertis cell tetap
juga ga bisa berubah adakah tehnik untuk merubah DTPicker tersebut Terima Kasih
atas pencerahannya file contoh terlampir #yiv9345011685 #yiv9345011685 --
#yiv9345011685ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}#yiv9345011685 #yiv9345011685ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv9345011685 #yiv9345011685ygrp-mkp #yiv9345011685hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9345011685 #yiv9345011685ygrp-mkp #yiv9345011685ads
{margin-bottom:10px;}#yiv9345011685 #yiv9345011685ygrp-mkp .yiv9345011685ad
{padding:0 0;}#yiv9345011685 #yiv9345011685ygrp-mkp .yiv9345011685ad p
{margin:0;}#yiv9345011685 #yiv9345011685ygrp-mkp .yiv9345011685ad a
{color:#0000ff;text-decoration:none;}#yiv9345011685 #yiv9345011685ygrp-sponsor
#yiv9345011685ygrp-lc {font-family:Arial;}#yiv9345011685
#yiv9345011685ygrp-sponsor #yiv9345011685ygrp-lc #yiv9345011685hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9345011685
#yiv9345011685ygrp-sponsor #yiv9345011685ygrp-lc .yiv9345011685ad
{margin-bottom:10px;padding:0 0;}#yiv9345011685 #yiv9345011685actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9345011685
#yiv9345011685activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9345011685
#yiv9345011685activity span {font-weight:700;}#yiv9345011685
#yiv9345011685activity span:first-child
{text-transform:uppercase;}#yiv9345011685 #yiv9345011685activity span a
{color:#5085b6;text-decoration:none;}#yiv9345011685 #yiv9345011685activity span
span {color:#ff7900;}#yiv9345011685 #yiv9345011685activity span
.yiv9345011685underline {text-decoration:underline;}#yiv9345011685
.yiv9345011685attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9345011685 .yiv9345011685attach div a
{text-decoration:none;}#yiv9345011685 .yiv9345011685attach img
{border:none;padding-right:5px;}#yiv9345011685 .yiv9345011685attach label
{display:block;margin-bottom:5px;}#yiv9345011685 .yiv9345011685attach label a
{text-decoration:none;}#yiv9345011685 blockquote {margin:0 0 0
4px;}#yiv9345011685 .yiv9345011685bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9345011685
.yiv9345011685bold a {text-decoration:none;}#yiv9345011685 dd.yiv9345011685last
p a {font-family:Verdana;font-weight:700;}#yiv9345011685 dd.yiv9345011685last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9345011685
dd.yiv9345011685last p span.yiv9345011685yshortcuts
{margin-right:0;}#yiv9345011685 div.yiv9345011685attach-table div div a
{text-decoration:none;}#yiv9345011685 div.yiv9345011685attach-table
{width:400px;}#yiv9345011685 div.yiv9345011685file-title a, #yiv9345011685
div.yiv9345011685file-title a:active, #yiv9345011685
div.yiv9345011685file-title a:hover, #yiv9345011685 div.yiv9345011685file-title
a:visited {text-decoration:none;}#yiv9345011685 div.yiv9345011685photo-title a,
#yiv9345011685 div.yiv9345011685photo-title a:active, #yiv9345011685
div.yiv9345011685photo-title a:hover, #yiv9345011685
div.yiv9345011685photo-title a:visited {text-decoration:none;}#yiv9345011685
div#yiv9345011685ygrp-mlmsg #yiv9345011685ygrp-msg p a
span.yiv9345011685yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9345011685
.yiv9345011685green {color:#628c2a;}#yiv9345011685 .yiv9345011685MsoNormal
{margin:0 0 0 0;}#yiv9345011685 o {font-size:0;}#yiv9345011685
#yiv9345011685photos div {float:left;width:72px;}#yiv9345011685
#yiv9345011685photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv9345011685
#yiv9345011685photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9345011685
#yiv9345011685reco-category {font-size:77%;}#yiv9345011685
#yiv9345011685reco-desc {font-size:77%;}#yiv9345011685 .yiv9345011685replbq
{margin:4px;}#yiv9345011685 #yiv9345011685ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9345011685 #yiv9345011685ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9345011685
#yiv9345011685ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9345011685
#yiv9345011685ygrp-mlmsg select, #yiv9345011685 input, #yiv9345011685 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9345011685
#yiv9345011685ygrp-mlmsg pre, #yiv9345011685 code {font:115%
monospace;}#yiv9345011685 #yiv9345011685ygrp-mlmsg *
{line-height:1.22em;}#yiv9345011685 #yiv9345011685ygrp-mlmsg #yiv9345011685logo
{padding-bottom:10px;}#yiv9345011685 #yiv9345011685ygrp-msg p a
{font-family:Verdana;}#yiv9345011685 #yiv9345011685ygrp-msg
p#yiv9345011685attach-count span {color:#1E66AE;font-weight:700;}#yiv9345011685
#yiv9345011685ygrp-reco #yiv9345011685reco-head
{color:#ff7900;font-weight:700;}#yiv9345011685 #yiv9345011685ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9345011685 #yiv9345011685ygrp-sponsor
#yiv9345011685ov li a {font-size:130%;text-decoration:none;}#yiv9345011685
#yiv9345011685ygrp-sponsor #yiv9345011685ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9345011685
#yiv9345011685ygrp-sponsor #yiv9345011685ov ul {margin:0;padding:0 0 0
8px;}#yiv9345011685 #yiv9345011685ygrp-text
{font-family:Georgia;}#yiv9345011685 #yiv9345011685ygrp-text p {margin:0 0 1em
0;}#yiv9345011685 #yiv9345011685ygrp-text tt {font-size:120%;}#yiv9345011685
#yiv9345011685ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9345011685
