Hai Modby.M, Untuk pertanyaan pertama saya lampirkan File berisi macro karya mbak Siti sebagai rujukan. File berisi Macro agar Compatible dengan MS Office 2007 ke bawah harus disave dengan extension .xls (Excel 97-2003 workbook). Sedangkan jika anda menggunakan Excel 2007 ke atas maka file berisi Macro bisa disimpan dengan,extension .xls (Excel 97-2003 Workbook)extension . xlsb (Excel Binary Workbook)extension . xlsm (Excel Macro-Enabled Workbook).
Salam,HK
From: "Modby Matsnawabi [email protected] [belajar-excel]"
<[email protected]>
To: belajar-excel <[email protected]>
Sent: Friday, 16 October 2015, 16:04
Subject: [belajar-excel] Macro simpan/copy otomatis [1 Attachment]
Dear rekan-rekan bexcel,,
mohon bantuan yang sudah pernah buat macro untuk simpan data otomatis/copy data
ke sheet lain. tolong di share macro nya yah..saya punya case terlampir..
tanya juga untuk excel dengan macro harus disave dengan file XLSM? apa nanti
akan compatible dengan ms office 2007 ke bawah..
terima kasih
Modby.M #yiv1976862942 -- #yiv1976862942ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1976862942
#yiv1976862942ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1976862942
#yiv1976862942ygrp-mkp #yiv1976862942hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv1976862942 #yiv1976862942ygrp-mkp #yiv1976862942ads
{margin-bottom:10px;}#yiv1976862942 #yiv1976862942ygrp-mkp .yiv1976862942ad
{padding:0 0;}#yiv1976862942 #yiv1976862942ygrp-mkp .yiv1976862942ad p
{margin:0;}#yiv1976862942 #yiv1976862942ygrp-mkp .yiv1976862942ad a
{color:#0000ff;text-decoration:none;}#yiv1976862942 #yiv1976862942ygrp-sponsor
#yiv1976862942ygrp-lc {font-family:Arial;}#yiv1976862942
#yiv1976862942ygrp-sponsor #yiv1976862942ygrp-lc #yiv1976862942hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1976862942
#yiv1976862942ygrp-sponsor #yiv1976862942ygrp-lc .yiv1976862942ad
{margin-bottom:10px;padding:0 0;}#yiv1976862942 #yiv1976862942actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1976862942
#yiv1976862942activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1976862942
#yiv1976862942activity span {font-weight:700;}#yiv1976862942
#yiv1976862942activity span:first-child
{text-transform:uppercase;}#yiv1976862942 #yiv1976862942activity span a
{color:#5085b6;text-decoration:none;}#yiv1976862942 #yiv1976862942activity span
span {color:#ff7900;}#yiv1976862942 #yiv1976862942activity span
.yiv1976862942underline {text-decoration:underline;}#yiv1976862942
.yiv1976862942attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv1976862942 .yiv1976862942attach div a
{text-decoration:none;}#yiv1976862942 .yiv1976862942attach img
{border:none;padding-right:5px;}#yiv1976862942 .yiv1976862942attach label
{display:block;margin-bottom:5px;}#yiv1976862942 .yiv1976862942attach label a
{text-decoration:none;}#yiv1976862942 blockquote {margin:0 0 0
4px;}#yiv1976862942 .yiv1976862942bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1976862942
.yiv1976862942bold a {text-decoration:none;}#yiv1976862942 dd.yiv1976862942last
p a {font-family:Verdana;font-weight:700;}#yiv1976862942 dd.yiv1976862942last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1976862942
dd.yiv1976862942last p span.yiv1976862942yshortcuts
{margin-right:0;}#yiv1976862942 div.yiv1976862942attach-table div div a
{text-decoration:none;}#yiv1976862942 div.yiv1976862942attach-table
{width:400px;}#yiv1976862942 div.yiv1976862942file-title a, #yiv1976862942
div.yiv1976862942file-title a:active, #yiv1976862942
div.yiv1976862942file-title a:hover, #yiv1976862942 div.yiv1976862942file-title
a:visited {text-decoration:none;}#yiv1976862942 div.yiv1976862942photo-title a,
#yiv1976862942 div.yiv1976862942photo-title a:active, #yiv1976862942
div.yiv1976862942photo-title a:hover, #yiv1976862942
div.yiv1976862942photo-title a:visited {text-decoration:none;}#yiv1976862942
div#yiv1976862942ygrp-mlmsg #yiv1976862942ygrp-msg p a
span.yiv1976862942yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1976862942
.yiv1976862942green {color:#628c2a;}#yiv1976862942 .yiv1976862942MsoNormal
{margin:0 0 0 0;}#yiv1976862942 o {font-size:0;}#yiv1976862942
#yiv1976862942photos div {float:left;width:72px;}#yiv1976862942
#yiv1976862942photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv1976862942
#yiv1976862942photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1976862942
#yiv1976862942reco-category {font-size:77%;}#yiv1976862942
#yiv1976862942reco-desc {font-size:77%;}#yiv1976862942 .yiv1976862942replbq
{margin:4px;}#yiv1976862942 #yiv1976862942ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv1976862942 #yiv1976862942ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1976862942
#yiv1976862942ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1976862942
#yiv1976862942ygrp-mlmsg select, #yiv1976862942 input, #yiv1976862942 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv1976862942
#yiv1976862942ygrp-mlmsg pre, #yiv1976862942 code {font:115%
monospace;}#yiv1976862942 #yiv1976862942ygrp-mlmsg *
{line-height:1.22em;}#yiv1976862942 #yiv1976862942ygrp-mlmsg #yiv1976862942logo
{padding-bottom:10px;}#yiv1976862942 #yiv1976862942ygrp-msg p a
{font-family:Verdana;}#yiv1976862942 #yiv1976862942ygrp-msg
p#yiv1976862942attach-count span {color:#1E66AE;font-weight:700;}#yiv1976862942
#yiv1976862942ygrp-reco #yiv1976862942reco-head
{color:#ff7900;font-weight:700;}#yiv1976862942 #yiv1976862942ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv1976862942 #yiv1976862942ygrp-sponsor
#yiv1976862942ov li a {font-size:130%;text-decoration:none;}#yiv1976862942
#yiv1976862942ygrp-sponsor #yiv1976862942ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv1976862942
#yiv1976862942ygrp-sponsor #yiv1976862942ov ul {margin:0;padding:0 0 0
8px;}#yiv1976862942 #yiv1976862942ygrp-text
{font-family:Georgia;}#yiv1976862942 #yiv1976862942ygrp-text p {margin:0 0 1em
0;}#yiv1976862942 #yiv1976862942ygrp-text tt {font-size:120%;}#yiv1976862942
#yiv1976862942ygrp-vital ul li:last-child {border-right:none
!important;}#yiv1976862942
Program input edit hapus index data.xls
Description: MS-Excel spreadsheet
