15 Messages
Digest #3518
2b
Fw: [belajar-excel] splite tabel menjadi beberapa tabel dalam 1 shee by "hendrik karnadi" hendrikkarnadi
2c
Fw: [belajar-excel] splite tabel menjadi beberapa tabel dalam 1 shee by "hendrik karnadi" hendrikkarnadi
Messages
Mon Jul 27, 2015 4:21 pm (PDT) . Posted by:
"Stephanus Nusanumba"
Cara menampilkan saldo akhir. Berikut File terlampirTerima kasihSalam, Stef - NTT
Mon Jul 27, 2015 8:32 pm (PDT) . Posted by:
"hendrik karnadi" hendrikkarnadi
Hai Stephanus,Akan lebih mudah jika bisa dilampirkan dummy file Excelnya...shg macronya bisa diuji coba...
Salam,HK
From: "Stephanus Nusanumba stef_ende@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Sunday, 26 July 2015, 7:36
Subject: [belajar-excel] Mohon Bantuannya [1 Attachment]
Cara menampilkan saldo akhir. Berikut File terlampirTerima kasihSalam, Stef - NTT
#yiv3247140217 #yiv3247140217 -- #yiv3247140217ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3247140217 #yiv3247140217ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3247140217 #yiv3247140217ygrp-mkp #yiv3247140217hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3247140217 #yiv3247140217ygrp-mkp #yiv3247140217ads {margin-bottom:10px;}#yiv3247140217 #yiv3247140217ygrp-mkp .yiv3247140217ad {padding:0 0;}#yiv3247140217 #yiv3247140217ygrp-mkp .yiv3247140217ad p {margin:0;}#yiv3247140217 #yiv3247140217ygrp-mkp .yiv3247140217ad a {color:#0000ff;text-decoration:none;}#yiv3247140217 #yiv3247140217ygrp-sponsor #yiv3247140217ygrp-lc {font-family:Arial;}#yiv3247140217 #yiv3247140217ygrp-sponsor #yiv3247140217ygrp-lc #yiv3247140217hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3247140217 #yiv3247140217ygrp-sponsor #yiv3247140217ygrp-lc .yiv3247140217ad {margin-bottom:10px;padding:0 0;}#yiv3247140217 #yiv3247140217actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3247140217 #yiv3247140217activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3247140217 #yiv3247140217activity span {font-weight:700;}#yiv3247140217 #yiv3247140217activity span:first-child {text-transform:uppercase;}#yiv3247140217 #yiv3247140217activity span a {color:#5085b6;text-decoration:none;}#yiv3247140217 #yiv3247140217activity span span {color:#ff7900;}#yiv3247140217 #yiv3247140217activity span .yiv3247140217underline {text-decoration:underline;}#yiv3247140217 .yiv3247140217attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3247140217 .yiv3247140217attach div a {text-decoration:none;}#yiv3247140217 .yiv3247140217attach img {border:none;padding-right:5px;}#yiv3247140217 .yiv3247140217attach label {display:block;margin-bottom:5px;}#yiv3247140217 .yiv3247140217attach label a {text-decoration:none;}#yiv3247140217 blockquote {margin:0 0 0 4px;}#yiv3247140217 .yiv3247140217bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3247140217 .yiv3247140217bold a {text-decoration:none;}#yiv3247140217 dd.yiv3247140217last p a {font-family:Verdana;font-weight:700;}#yiv3247140217 dd.yiv3247140217last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3247140217 dd.yiv3247140217last p span.yiv3247140217yshortcuts {margin-right:0;}#yiv3247140217 div.yiv3247140217attach-table div div a {text-decoration:none;}#yiv3247140217 div.yiv3247140217attach-table {width:400px;}#yiv3247140217 div.yiv3247140217file-title a, #yiv3247140217 div.yiv3247140217file-title a:active, #yiv3247140217 div.yiv3247140217file-title a:hover, #yiv3247140217 div.yiv3247140217file-title a:visited {text-decoration:none;}#yiv3247140217 div.yiv3247140217photo-title a, #yiv3247140217 div.yiv3247140217photo-title a:active, #yiv3247140217 div.yiv3247140217photo-title a:hover, #yiv3247140217 div.yiv3247140217photo-title a:visited {text-decoration:none;}#yiv3247140217 div#yiv3247140217ygrp-mlmsg #yiv3247140217ygrp-msg p a span.yiv3247140217yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3247140217 .yiv3247140217green {color:#628c2a;}#yiv3247140217 .yiv3247140217MsoNormal {margin:0 0 0 0;}#yiv3247140217 o {font-size:0;}#yiv3247140217 #yiv3247140217photos div {float:left;width:72px;}#yiv3247140217 #yiv3247140217photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3247140217 #yiv3247140217photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3247140217 #yiv3247140217reco-category {font-size:77%;}#yiv3247140217 #yiv3247140217reco-desc {font-size:77%;}#yiv3247140217 .yiv3247140217replbq {margin:4px;}#yiv3247140217 #yiv3247140217ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3247140217 #yiv3247140217ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3247140217 #yiv3247140217ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3247140217 #yiv3247140217ygrp-mlmsg select, #yiv3247140217 input, #yiv3247140217 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3247140217 #yiv3247140217ygrp-mlmsg pre, #yiv3247140217 code {font:115% monospace;}#yiv3247140217 #yiv3247140217ygrp-mlmsg * {line-height:1.22em;}#yiv3247140217 #yiv3247140217ygrp-mlmsg #yiv3247140217logo {padding-bottom:10px;}#yiv3247140217 #yiv3247140217ygrp-msg p a {font-family:Verdana;}#yiv3247140217 #yiv3247140217ygrp-msg p#yiv3247140217attach-count span {color:#1E66AE;font-weight:700;}#yiv3247140217 #yiv3247140217ygrp-reco #yiv3247140217reco-head {color:#ff7900;font-weight:700;}#yiv3247140217 #yiv3247140217ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3247140217 #yiv3247140217ygrp-sponsor #yiv3247140217ov li a {font-size:130%;text-decoration:none;}#yiv3247140217 #yiv3247140217ygrp-sponsor #yiv3247140217ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3247140217 #yiv3247140217ygrp-sponsor #yiv3247140217ov ul {margin:0;padding:0 0 0 8px;}#yiv3247140217 #yiv3247140217ygrp-text {font-family:Georgia;}#yiv3247140217 #yiv3247140217ygrp-text p {margin:0 0 1em 0;}#yiv3247140217 #yiv3247140217ygrp-text tt {font-size:120%;}#yiv3247140217 #yiv3247140217ygrp-vital ul li:last-child {border-right:none !important;}#yiv3247140217
Salam,HK
From: "Stephanus Nusanumba stef_ende@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Sunday, 26 July 2015, 7:36
Subject: [belajar-excel] Mohon Bantuannya [1 Attachment]
Cara menampilkan saldo akhir. Berikut File terlampirTerima kasihSalam, Stef - NTT
#yiv3247140217 #yiv3247140217 -- #yiv3247140217ygrp-
Mon Jul 27, 2015 4:22 pm (PDT) . Posted by:
"Walsoyo"
"Mohon bantuan bagaimana memisahkan data dalam satu tabel yang sesuai
dengan kode barang menjadi beberapa tabel dalam 1 sheet dengan VBA
Macro. file terlampir.terimakasih sebelumnya."
dengan kode barang menjadi beberapa tabel dalam 1 sheet dengan VBA
Macro. file terlampir.terimakas
Mon Jul 27, 2015 8:04 pm (PDT) . Posted by:
"hendrik karnadi" hendrikkarnadi
File terlampir (warisan si mbah) mungkin bisa menjadi bahan rujukan.
Salam,HK
----- Forwarded Message -----
From: "Walsoyo soyomakmur@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Sunday, 26 July 2015, 13:35
Subject: [belajar-excel] splite tabel menjadi beberapa tabel dalam 1 sheet [1 Attachment]
"Mohon bantuan bagaimana memisahkan data dalam satu tabel yang sesuai
dengan kode barang menjadi beberapa tabel dalam 1 sheet dengan VBA
Macro. file terlampir.terimakasih sebelumnya."
#yiv8040109532 #yiv8040109532 -- #yiv8040109532ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8040109532 #yiv8040109532ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8040109532 #yiv8040109532ygrp-mkp #yiv8040109532hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8040109532 #yiv8040109532ygrp-mkp #yiv8040109532ads {margin-bottom:10px;}#yiv8040109532 #yiv8040109532ygrp-mkp .yiv8040109532ad {padding:0 0;}#yiv8040109532 #yiv8040109532ygrp-mkp .yiv8040109532ad p {margin:0;}#yiv8040109532 #yiv8040109532ygrp-mkp .yiv8040109532ad a {color:#0000ff;text-decoration:none;}#yiv8040109532 #yiv8040109532ygrp-sponsor #yiv8040109532ygrp-lc {font-family:Arial;}#yiv8040109532 #yiv8040109532ygrp-sponsor #yiv8040109532ygrp-lc #yiv8040109532hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8040109532 #yiv8040109532ygrp-sponsor #yiv8040109532ygrp-lc .yiv8040109532ad {margin-bottom:10px;padding:0 0;}#yiv8040109532 #yiv8040109532actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8040109532 #yiv8040109532activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8040109532 #yiv8040109532activity span {font-weight:700;}#yiv8040109532 #yiv8040109532activity span:first-child {text-transform:uppercase;}#yiv8040109532 #yiv8040109532activity span a {color:#5085b6;text-decoration:none;}#yiv8040109532 #yiv8040109532activity span span {color:#ff7900;}#yiv8040109532 #yiv8040109532activity span .yiv8040109532underline {text-decoration:underline;}#yiv8040109532 .yiv8040109532attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8040109532 .yiv8040109532attach div a {text-decoration:none;}#yiv8040109532 .yiv8040109532attach img {border:none;padding-right:5px;}#yiv8040109532 .yiv8040109532attach label {display:block;margin-bottom:5px;}#yiv8040109532 .yiv8040109532attach label a {text-decoration:none;}#yiv8040109532 blockquote {margin:0 0 0 4px;}#yiv8040109532 .yiv8040109532bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8040109532 .yiv8040109532bold a {text-decoration:none;}#yiv8040109532 dd.yiv8040109532last p a {font-family:Verdana;font-weight:700;}#yiv8040109532 dd.yiv8040109532last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8040109532 dd.yiv8040109532last p span.yiv8040109532yshortcuts {margin-right:0;}#yiv8040109532 div.yiv8040109532attach-table div div a {text-decoration:none;}#yiv8040109532 div.yiv8040109532attach-table {width:400px;}#yiv8040109532 div.yiv8040109532file-title a, #yiv8040109532 div.yiv8040109532file-title a:active, #yiv8040109532 div.yiv8040109532file-title a:hover, #yiv8040109532 div.yiv8040109532file-title a:visited {text-decoration:none;}#yiv8040109532 div.yiv8040109532photo-title a, #yiv8040109532 div.yiv8040109532photo-title a:active, #yiv8040109532 div.yiv8040109532photo-title a:hover, #yiv8040109532 div.yiv8040109532photo-title a:visited {text-decoration:none;}#yiv8040109532 div#yiv8040109532ygrp-mlmsg #yiv8040109532ygrp-msg p a span.yiv8040109532yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8040109532 .yiv8040109532green {color:#628c2a;}#yiv8040109532 .yiv8040109532MsoNormal {margin:0 0 0 0;}#yiv8040109532 o {font-size:0;}#yiv8040109532 #yiv8040109532photos div {float:left;width:72px;}#yiv8040109532 #yiv8040109532photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv8040109532 #yiv8040109532photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8040109532 #yiv8040109532reco-category {font-size:77%;}#yiv8040109532 #yiv8040109532reco-desc {font-size:77%;}#yiv8040109532 .yiv8040109532replbq {margin:4px;}#yiv8040109532 #yiv8040109532ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8040109532 #yiv8040109532ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8040109532 #yiv8040109532ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8040109532 #yiv8040109532ygrp-mlmsg select, #yiv8040109532 input, #yiv8040109532 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8040109532 #yiv8040109532ygrp-mlmsg pre, #yiv8040109532 code {font:115% monospace;}#yiv8040109532 #yiv8040109532ygrp-mlmsg * {line-height:1.22em;}#yiv8040109532 #yiv8040109532ygrp-mlmsg #yiv8040109532logo {padding-bottom:10px;}#yiv8040109532 #yiv8040109532ygrp-msg p a {font-family:Verdana;}#yiv8040109532 #yiv8040109532ygrp-msg p#yiv8040109532attach-count span {color:#1E66AE;font-weight:700;}#yiv8040109532 #yiv8040109532ygrp-reco #yiv8040109532reco-head {color:#ff7900;font-weight:700;}#yiv8040109532 #yiv8040109532ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8040109532 #yiv8040109532ygrp-sponsor #yiv8040109532ov li a {font-size:130%;text-decoration:none;}#yiv8040109532 #yiv8040109532ygrp-sponsor #yiv8040109532ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8040109532 #yiv8040109532ygrp-sponsor #yiv8040109532ov ul {margin:0;padding:0 0 0 8px;}#yiv8040109532 #yiv8040109532ygrp-text {font-family:Georgia;}#yiv8040109532 #yiv8040109532ygrp-text p {margin:0 0 1em 0;}#yiv8040109532 #yiv8040109532ygrp-text tt {font-size:120%;}#yiv8040109532 #yiv8040109532ygrp-vital ul li:last-child {border-right:none !important;}#yiv8040109532
Salam,HK
----- Forwarded Message -----
From: "Walsoyo soyomakmur@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Sunday, 26 July 2015, 13:35
Subject: [belajar-excel] splite tabel menjadi beberapa tabel dalam 1 sheet [1 Attachment]
"Mohon bantuan bagaimana memisahkan data dalam satu tabel yang sesuai
dengan kode barang menjadi beberapa tabel dalam 1 sheet dengan VBA
Macro. file terlampir.terimakas
#yiv8040109532 #yiv8040109532 -- #yiv8040109532ygrp-
Mon Jul 27, 2015 8:06 pm (PDT) . Posted by:
"hendrik karnadi" hendrikkarnadi
Maaf, lamp ketinggalan....
----- Forwarded Message -----
From: hendrik karnadi <hendrikkarnadi@yahoo.com>
To: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
Sent: Tuesday, 28 July 2015, 10:04
Subject: Fw: [belajar-excel] splite tabel menjadi beberapa tabel dalam 1 sheet [1 Attachment]
File terlampir (warisan si mbah) mungkin bisa menjadi bahan rujukan.
Salam,HK
----- Forwarded Message -----
From: "Walsoyo soyomakmur@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Sunday, 26 July 2015, 13:35
Subject: [belajar-excel] splite tabel menjadi beberapa tabel dalam 1 sheet [1 Attachment]
"Mohon bantuan bagaimana memisahkan data dalam satu tabel yang sesuai
dengan kode barang menjadi beberapa tabel dalam 1 sheet dengan VBA
Macro. file terlampir.terimakasih sebelumnya."
#yiv7070318494 -- #yiv7070318494ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7070318494 #yiv7070318494ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7070318494 #yiv7070318494ygrp-mkp #yiv7070318494hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7070318494 #yiv7070318494ygrp-mkp #yiv7070318494ads {margin-bottom:10px;}#yiv7070318494 #yiv7070318494ygrp-mkp .yiv7070318494ad {padding:0 0;}#yiv7070318494 #yiv7070318494ygrp-mkp .yiv7070318494ad p {margin:0;}#yiv7070318494 #yiv7070318494ygrp-mkp .yiv7070318494ad a {color:#0000ff;text-decoration:none;}#yiv7070318494 #yiv7070318494ygrp-sponsor #yiv7070318494ygrp-lc {font-family:Arial;}#yiv7070318494 #yiv7070318494ygrp-sponsor #yiv7070318494ygrp-lc #yiv7070318494hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7070318494 #yiv7070318494ygrp-sponsor #yiv7070318494ygrp-lc .yiv7070318494ad {margin-bottom:10px;padding:0 0;}#yiv7070318494 #yiv7070318494actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7070318494 #yiv7070318494activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7070318494 #yiv7070318494activity span {font-weight:700;}#yiv7070318494 #yiv7070318494activity span:first-child {text-transform:uppercase;}#yiv7070318494 #yiv7070318494activity span a {color:#5085b6;text-decoration:none;}#yiv7070318494 #yiv7070318494activity span span {color:#ff7900;}#yiv7070318494 #yiv7070318494activity span .yiv7070318494underline {text-decoration:underline;}#yiv7070318494 .yiv7070318494attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7070318494 .yiv7070318494attach div a {text-decoration:none;}#yiv7070318494 .yiv7070318494attach img {border:none;padding-right:5px;}#yiv7070318494 .yiv7070318494attach label {display:block;margin-bottom:5px;}#yiv7070318494 .yiv7070318494attach label a {text-decoration:none;}#yiv7070318494 blockquote {margin:0 0 0 4px;}#yiv7070318494 .yiv7070318494bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7070318494 .yiv7070318494bold a {text-decoration:none;}#yiv7070318494 dd.yiv7070318494last p a {font-family:Verdana;font-weight:700;}#yiv7070318494 dd.yiv7070318494last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7070318494 dd.yiv7070318494last p span.yiv7070318494yshortcuts {margin-right:0;}#yiv7070318494 div.yiv7070318494attach-table div div a {text-decoration:none;}#yiv7070318494 div.yiv7070318494attach-table {width:400px;}#yiv7070318494 div.yiv7070318494file-title a, #yiv7070318494 div.yiv7070318494file-title a:active, #yiv7070318494 div.yiv7070318494file-title a:hover, #yiv7070318494 div.yiv7070318494file-title a:visited {text-decoration:none;}#yiv7070318494 div.yiv7070318494photo-title a, #yiv7070318494 div.yiv7070318494photo-title a:active, #yiv7070318494 div.yiv7070318494photo-title a:hover, #yiv7070318494 div.yiv7070318494photo-title a:visited {text-decoration:none;}#yiv7070318494 div#yiv7070318494ygrp-mlmsg #yiv7070318494ygrp-msg p a span.yiv7070318494yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7070318494 .yiv7070318494green {color:#628c2a;}#yiv7070318494 .yiv7070318494MsoNormal {margin:0 0 0 0;}#yiv7070318494 o {font-size:0;}#yiv7070318494 #yiv7070318494photos div {float:left;width:72px;}#yiv7070318494 #yiv7070318494photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv7070318494 #yiv7070318494photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7070318494 #yiv7070318494reco-category {font-size:77%;}#yiv7070318494 #yiv7070318494reco-desc {font-size:77%;}#yiv7070318494 .yiv7070318494replbq {margin:4px;}#yiv7070318494 #yiv7070318494ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7070318494 #yiv7070318494ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7070318494 #yiv7070318494ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7070318494 #yiv7070318494ygrp-mlmsg select, #yiv7070318494 input, #yiv7070318494 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7070318494 #yiv7070318494ygrp-mlmsg pre, #yiv7070318494 code {font:115% monospace;}#yiv7070318494 #yiv7070318494ygrp-mlmsg * {line-height:1.22em;}#yiv7070318494 #yiv7070318494ygrp-mlmsg #yiv7070318494logo {padding-bottom:10px;}#yiv7070318494 #yiv7070318494ygrp-msg p a {font-family:Verdana;}#yiv7070318494 #yiv7070318494ygrp-msg p#yiv7070318494attach-count span {color:#1E66AE;font-weight:700;}#yiv7070318494 #yiv7070318494ygrp-reco #yiv7070318494reco-head {color:#ff7900;font-weight:700;}#yiv7070318494 #yiv7070318494ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7070318494 #yiv7070318494ygrp-sponsor #yiv7070318494ov li a {font-size:130%;text-decoration:none;}#yiv7070318494 #yiv7070318494ygrp-sponsor #yiv7070318494ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7070318494 #yiv7070318494ygrp-sponsor #yiv7070318494ov ul {margin:0;padding:0 0 0 8px;}#yiv7070318494 #yiv7070318494ygrp-text {font-family:Georgia;}#yiv7070318494 #yiv7070318494ygrp-text p {margin:0 0 1em 0;}#yiv7070318494 #yiv7070318494ygrp-text tt {font-size:120%;}#yiv7070318494 #yiv7070318494ygrp-vital ul li:last-child {border-right:none !important;}#yiv7070318494
----- Forwarded Message -----
From: hendrik karnadi <hendrikkarnadi@yahoo.com>
To: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
Sent: Tuesday, 28 July 2015, 10:04
Subject: Fw: [belajar-excel] splite tabel menjadi beberapa tabel dalam 1 sheet [1 Attachment]
File terlampir (warisan si mbah) mungkin bisa menjadi bahan rujukan.
Salam,HK
----- Forwarded Message -----
From: "Walsoyo soyomakmur@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Sunday, 26 July 2015, 13:35
Subject: [belajar-excel] splite tabel menjadi beberapa tabel dalam 1 sheet [1 Attachment]
"Mohon bantuan bagaimana memisahkan data dalam satu tabel yang sesuai
dengan kode barang menjadi beberapa tabel dalam 1 sheet dengan VBA
Macro. file terlampir.terimakas
#yiv7070318494 -- #yiv7070318494ygrp-
Mon Jul 27, 2015 4:23 pm (PDT) . Posted by:
yonikriwul
Rekan Rekan ......
Per 1 Juli kemaren dapat tambahan tugas untuk menyelesaikan faktur pajak melalui e-faktur pajak
setelah saya coba ternyata banyak sekali inputan yang harus diketikkan, karena harus memasukkan per item barang. sebenarnya ada menu import untuk mengambil file type CSV, namun setelah saya buka ternyata struktur tabelnya membuat saya bingung. Mungkin ada rekan rekan yang punya referensi template untuk Faktur Pajak Keluaran untuk e-faktur Pajak? Mohon advice dari rekan rekan exceller untuk solusi masalah yang sedang saya hadapi ini. Terima kasih sebelumnya
Regards
Yoni
Per 1 Juli kemaren dapat tambahan tugas untuk menyelesaikan faktur pajak melalui e-faktur pajak
setelah saya coba ternyata banyak sekali inputan yang harus diketikkan, karena harus memasukkan per item barang. sebenarnya ada menu import untuk mengambil file type CSV, namun setelah saya buka ternyata struktur tabelnya membuat saya bingung. Mungkin ada rekan rekan yang punya referensi template untuk Faktur Pajak Keluaran untuk e-faktur Pajak? Mohon advice dari rekan rekan exceller untuk solusi masalah yang sedang saya hadapi ini. Terima kasih sebelumnya
Regards
Yoni
Mon Jul 27, 2015 4:26 pm (PDT) . Posted by:
"Andre Rahmaidy" andree_bpdsumbar
Dear Beexceller
Saya mau tanya rumus exel merubah format tanggal yang dibuat secara manual(ketikan)misalnya 17 Agustus 2015, sebelumnya saya udah coba merubahnya dengan menggunakan format cells number>> date akan tetapi formatnya ga mau berubah sesuai dengan yang diinginkan 17-08-2015.. berhuhung datanya sangat banyak gimana solusinya beexceller, file terlampir.
--- Mods ---
File lampiran yang melebihi 250KB dilepas dari email. Silakan penanya mengirimkan ulang file lampiran yang diusahakan maksimal 250KB dengan cara me-reply email ini.
------------
Saya mau tanya rumus exel merubah format tanggal yang dibuat secara manual(ketikan)
--- Mods ---
File lampiran yang melebihi 250KB dilepas dari email. Silakan penanya mengirimkan ulang file lampiran yang diusahakan maksimal 250KB dengan cara me-reply email ini.
------------
Mon Jul 27, 2015 6:33 pm (PDT) . Posted by:
"Andre Rahmaidy" andree_bpdsumbar
Dear Beexcellermohon maaf sebelumnya atas file lampiran yang melebihi size dari aturan milis ini dan posting kedua yang melampiri email lain.. berikut ini saya kirim kembali file lampirannya..
Wassalam
Andree
Wassalam
Andree
Mon Jul 27, 2015 7:40 pm (PDT) . Posted by:
"Heri Pamungkas ( Gmail )" dchoosen88
السَّÙ„َامُ عَÙ„َÙŠْÙƒُÙ…ْ ÙˆَرَØْÙ…َØ©ُ اللهِ ÙˆَبَرَÙƒَاتُÙ‡ُ
Semangat pagi,.
Mungkin bisa begini.
ÙˆَالسَّÙ„َامُ عَÙ„َÙŠْÙƒُÙ…ْ ÙˆَرَØْÙ…َØ©ُ اللهِ ÙˆَبَرَÙƒَاتُÙ‡ُ
Warm Regards,
On 28/07/2015 8:24, Andre Rahmaidy andree_bpdsumbar@yahoo.co.id
[belajar-excel] wrote:
> Dear Beexceller
> mohon maaf sebelumnya atas file lampiran yang melebihi size dari
> aturan milis ini dan posting kedua yang melampiri email lain.. berikut
> ini saya kirim kembali file lampirannya.
>
>
> Wassalam
>
> Andree
>
Mon Jul 27, 2015 7:32 pm (PDT) . Posted by:
"Mr. Kid" nmkid.family@ymail.com
Coba dilampirkan 25 sheet yang kosong (tidak ada data apapun) dan 19
userform tersebut.
2015-07-23 18:22 GMT+07:00 yudha cahayaoptikmandiri@yahoo.co.id
[belajar-excel] <belajar-excel@yahoogroups.com>:
>
>
> Salam Om Kid
> nah itu masalahnya Om kid, filenya sampai 25 mb dan ada 25 sheet, 19
> userform..jadi saya bingung kesalahannya ada dimana..
> yg no 1 itu akan keluar pada saat saya buka file
>
> dan yg no 2 ditiap sheet terdapat button untuk kembali ke sheet "menu
> utama" dan script nya sbb
>
> sheet3.visible = xlSheetVisible ' <=
> sheet3.activate
> sheet1.visible = xlSheetVeryhidden
>
> nah peringatan itu muncul saat button di klik lalu saat diklik debug akan
> menandai (warna kuning) yg ada tanda panah
>
> demikian yg bisa saya sampaikan
> sekali lagi mohon maaf blm bisa menyampaikan lampiran karena masih blm
> tahu yg mana yg mau dilampirkan
> salam
> yudha
>
> "'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]" <
> belajar-excel@yahoogroups.com> menulis:
>
> >Adakah contoh file yang bisa di-share, yang berisi command button,
> userform
> >kosongan dan beberapa sheet kosong yang bisa memunculkan error tersebut ?
> >
> >
> >2015-07-23 9:31 GMT+07:00 yudha cahayaoptikmandiri@yahoo.co.id
> >[belajar-excel] <belajar-excel@yahoogroups.com>:
> >
> >>
> >>
> >> Salam master,
> >> mohon maaf lahir dan batin
> >>
> >> mau nanya nih..
> >> 1. kenapa file ku keluar peringatan run -time error '57121'
> >> application-defined or object-defined error
> >> 2. trus apabila kita pindah sheet dgn mengeklik tombol perintah, keluar
> >> lagi peringatan
> >> "Can't exit design mode because Control ' CommandButton1' can not be
> >> created "
> >> oh ya..kalo tekan tombol untuk masuk ke userform tidak keluar peringaran
> >> tsb..jadi hanya pindah sheet yg begitu
> >>
> >> mohon maaf kalo pertanyaannya membingungkan..
> >>
> >> salam,
> >> yudha
> >>
> >>
>
>
userform tersebut.
2015-07-23 18:22 GMT+07:00 yudha cahayaoptikmandiri@yahoo.co.id
[belajar-excel] <belajar-excel@yahoogroups.com>:
>
>
> Salam Om Kid
> nah itu masalahnya Om kid, filenya sampai 25 mb dan ada 25 sheet, 19
> userform..jadi saya bingung kesalahannya ada dimana..
> yg no 1 itu akan keluar pada saat saya buka file
>
> dan yg no 2 ditiap sheet terdapat button untuk kembali ke sheet "menu
> utama" dan script nya sbb
>
> sheet3.visible = xlSheetVisible ' <=
> sheet3.activate
> sheet1.visible = xlSheetVeryhidden
>
> nah peringatan itu muncul saat button di klik lalu saat diklik debug akan
> menandai (warna kuning) yg ada tanda panah
>
> demikian yg bisa saya sampaikan
> sekali lagi mohon maaf blm bisa menyampaikan lampiran karena masih blm
> tahu yg mana yg mau dilampirkan
> salam
> yudha
>
> "'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]" <
> belajar-excel@yahoogroups.com> menulis:
>
> >Adakah contoh file yang bisa di-share, yang berisi command button,
> userform
> >kosongan dan beberapa sheet kosong yang bisa memunculkan error tersebut ?
> >
> >
> >2015-07-23 9:31 GMT+07:00 yudha cahayaoptikmandiri@yahoo.co.id
> >[belajar-excel] <belajar-excel@yahoogroups.com>:
> >
> >>
> >>
> >> Salam master,
> >> mohon maaf lahir dan batin
> >>
> >> mau nanya nih..
> >> 1. kenapa file ku keluar peringatan run -time error '57121&#
> >> application-
> >> 2. trus apabila kita pindah sheet dgn mengeklik tombol perintah, keluar
> >> lagi peringatan
> >> "Can'
> >> created "
> >> oh ya..kalo tekan tombol untuk masuk ke userform tidak keluar peringaran
> >> tsb..jadi hanya pindah sheet yg begitu
> >>
> >> mohon maaf kalo pertanyaannya membingungkan.
> >>
> >> salam,
> >> yudha
> >>
> >>
>
>
Mon Jul 27, 2015 11:05 pm (PDT) . Posted by:
"Andre Rahmaidy" andree_bpdsumbar
Dear Beexceller
terimakasih atas bantuan formulanya, cuma di ms office saya fungsi DATEVALUE kok berubah jadi eror ya seperti ini #value!..
Wassalam
Andree
Mon Jul 27, 2015 11:37 pm (PDT) . Posted by:
"hendrik karnadi" hendrikkarnadi
Hai Andree,Sdh cek regional settingnya ?
Salam,HK
----- Forwarded Message -----
From: "Andre Rahmaidy andree_bpdsumbar@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Tuesday, 28 July 2015, 13:02
Subject: [belajar-excel] Trs: Formula Format Tanggal
Dear Beexceller
terimakasih atas bantuan formulanya, cuma di ms office saya fungsi DATEVALUE kok berubah jadi eror ya seperti ini #value!..
Wassalam
Andree
#yiv7256361247 #yiv7256361247 -- #yiv7256361247ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7256361247 #yiv7256361247ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7256361247 #yiv7256361247ygrp-mkp #yiv7256361247hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7256361247 #yiv7256361247ygrp-mkp #yiv7256361247ads {margin-bottom:10px;}#yiv7256361247 #yiv7256361247ygrp-mkp .yiv7256361247ad {padding:0 0;}#yiv7256361247 #yiv7256361247ygrp-mkp .yiv7256361247ad p {margin:0;}#yiv7256361247 #yiv7256361247ygrp-mkp .yiv7256361247ad a {color:#0000ff;text-decoration:none;}#yiv7256361247 #yiv7256361247ygrp-sponsor #yiv7256361247ygrp-lc {font-family:Arial;}#yiv7256361247 #yiv7256361247ygrp-sponsor #yiv7256361247ygrp-lc #yiv7256361247hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7256361247 #yiv7256361247ygrp-sponsor #yiv7256361247ygrp-lc .yiv7256361247ad {margin-bottom:10px;padding:0 0;}#yiv7256361247 #yiv7256361247actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7256361247 #yiv7256361247activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7256361247 #yiv7256361247activity span {font-weight:700;}#yiv7256361247 #yiv7256361247activity span:first-child {text-transform:uppercase;}#yiv7256361247 #yiv7256361247activity span a {color:#5085b6;text-decoration:none;}#yiv7256361247 #yiv7256361247activity span span {color:#ff7900;}#yiv7256361247 #yiv7256361247activity span .yiv7256361247underline {text-decoration:underline;}#yiv7256361247 .yiv7256361247attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7256361247 .yiv7256361247attach div a {text-decoration:none;}#yiv7256361247 .yiv7256361247attach img {border:none;padding-right:5px;}#yiv7256361247 .yiv7256361247attach label {display:block;margin-bottom:5px;}#yiv7256361247 .yiv7256361247attach label a {text-decoration:none;}#yiv7256361247 blockquote {margin:0 0 0 4px;}#yiv7256361247 .yiv7256361247bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7256361247 .yiv7256361247bold a {text-decoration:none;}#yiv7256361247 dd.yiv7256361247last p a {font-family:Verdana;font-weight:700;}#yiv7256361247 dd.yiv7256361247last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7256361247 dd.yiv7256361247last p span.yiv7256361247yshortcuts {margin-right:0;}#yiv7256361247 div.yiv7256361247attach-table div div a {text-decoration:none;}#yiv7256361247 div.yiv7256361247attach-table {width:400px;}#yiv7256361247 div.yiv7256361247file-title a, #yiv7256361247 div.yiv7256361247file-title a:active, #yiv7256361247 div.yiv7256361247file-title a:hover, #yiv7256361247 div.yiv7256361247file-title a:visited {text-decoration:none;}#yiv7256361247 div.yiv7256361247photo-title a, #yiv7256361247 div.yiv7256361247photo-title a:active, #yiv7256361247 div.yiv7256361247photo-title a:hover, #yiv7256361247 div.yiv7256361247photo-title a:visited {text-decoration:none;}#yiv7256361247 div#yiv7256361247ygrp-mlmsg #yiv7256361247ygrp-msg p a span.yiv7256361247yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7256361247 .yiv7256361247green {color:#628c2a;}#yiv7256361247 .yiv7256361247MsoNormal {margin:0 0 0 0;}#yiv7256361247 o {font-size:0;}#yiv7256361247 #yiv7256361247photos div {float:left;width:72px;}#yiv7256361247 #yiv7256361247photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv7256361247 #yiv7256361247photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7256361247 #yiv7256361247reco-category {font-size:77%;}#yiv7256361247 #yiv7256361247reco-desc {font-size:77%;}#yiv7256361247 .yiv7256361247replbq {margin:4px;}#yiv7256361247 #yiv7256361247ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7256361247 #yiv7256361247ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7256361247 #yiv7256361247ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7256361247 #yiv7256361247ygrp-mlmsg select, #yiv7256361247 input, #yiv7256361247 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7256361247 #yiv7256361247ygrp-mlmsg pre, #yiv7256361247 code {font:115% monospace;}#yiv7256361247 #yiv7256361247ygrp-mlmsg * {line-height:1.22em;}#yiv7256361247 #yiv7256361247ygrp-mlmsg #yiv7256361247logo {padding-bottom:10px;}#yiv7256361247 #yiv7256361247ygrp-msg p a {font-family:Verdana;}#yiv7256361247 #yiv7256361247ygrp-msg p#yiv7256361247attach-count span {color:#1E66AE;font-weight:700;}#yiv7256361247 #yiv7256361247ygrp-reco #yiv7256361247reco-head {color:#ff7900;font-weight:700;}#yiv7256361247 #yiv7256361247ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7256361247 #yiv7256361247ygrp-sponsor #yiv7256361247ov li a {font-size:130%;text-decoration:none;}#yiv7256361247 #yiv7256361247ygrp-sponsor #yiv7256361247ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7256361247 #yiv7256361247ygrp-sponsor #yiv7256361247ov ul {margin:0;padding:0 0 0 8px;}#yiv7256361247 #yiv7256361247ygrp-text {font-family:Georgia;}#yiv7256361247 #yiv7256361247ygrp-text p {margin:0 0 1em 0;}#yiv7256361247 #yiv7256361247ygrp-text tt {font-size:120%;}#yiv7256361247 #yiv7256361247ygrp-vital ul li:last-child {border-right:none !important;}#yiv7256361247
Salam,HK
----- Forwarded Message -----
From: "Andre Rahmaidy andree_bpdsumbar@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Tuesday, 28 July 2015, 13:02
Subject: [belajar-excel] Trs: Formula Format Tanggal
Dear Beexceller
terimakasih atas bantuan formulanya, cuma di ms office saya fungsi DATEVALUE kok berubah jadi eror ya seperti ini #value!..
Wassalam
Andree
#yiv7256361247 #yiv7256361247 -- #yiv7256361247ygrp-
Tue Jul 28, 2015 12:04 am (PDT) . Posted by:
"Andre Rahmaidy" andree_bpdsumbar
Dear Pak Hendrik
Terimkasih atas infonya pak.. kalau regional settingnya ga dirubah emang ga bisa jalan formula DATEVALUEnya pak?? kebetulan seting regional pc saya harus english pak.
Pada Selasa, 28 Juli 2015 13:37, "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Hai Andree,Sdh cek regional settingnya ?
Salam,HK
----- Forwarded Message -----
From: "Andre Rahmaidy andree_bpdsumbar@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Tuesday, 28 July 2015, 13:02
Subject: [belajar-excel] Trs: Formula Format Tanggal
Dear Beexceller
terimakasih atas bantuan formulanya, cuma di ms office saya fungsi DATEVALUE kok berubah jadi eror ya seperti ini #value!..
Wassalam
Andree
#yiv6806981338 #yiv6806981338 -- #yiv6806981338ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6806981338 #yiv6806981338ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6806981338 #yiv6806981338ygrp-mkp #yiv6806981338hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6806981338 #yiv6806981338ygrp-mkp #yiv6806981338ads {margin-bottom:10px;}#yiv6806981338 #yiv6806981338ygrp-mkp .yiv6806981338ad {padding:0 0;}#yiv6806981338 #yiv6806981338ygrp-mkp .yiv6806981338ad p {margin:0;}#yiv6806981338 #yiv6806981338ygrp-mkp .yiv6806981338ad a {color:#0000ff;text-decoration:none;}#yiv6806981338 #yiv6806981338ygrp-sponsor #yiv6806981338ygrp-lc {font-family:Arial;}#yiv6806981338 #yiv6806981338ygrp-sponsor #yiv6806981338ygrp-lc #yiv6806981338hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6806981338 #yiv6806981338ygrp-sponsor #yiv6806981338ygrp-lc .yiv6806981338ad {margin-bottom:10px;padding:0 0;}#yiv6806981338 #yiv6806981338actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6806981338 #yiv6806981338activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6806981338 #yiv6806981338activity span {font-weight:700;}#yiv6806981338 #yiv6806981338activity span:first-child {text-transform:uppercase;}#yiv6806981338 #yiv6806981338activity span a {color:#5085b6;text-decoration:none;}#yiv6806981338 #yiv6806981338activity span span {color:#ff7900;}#yiv6806981338 #yiv6806981338activity span .yiv6806981338underline {text-decoration:underline;}#yiv6806981338 .yiv6806981338attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6806981338 .yiv6806981338attach div a {text-decoration:none;}#yiv6806981338 .yiv6806981338attach img {border:none;padding-right:5px;}#yiv6806981338 .yiv6806981338attach label {display:block;margin-bottom:5px;}#yiv6806981338 .yiv6806981338attach label a {text-decoration:none;}#yiv6806981338 blockquote {margin:0 0 0 4px;}#yiv6806981338 .yiv6806981338bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6806981338 .yiv6806981338bold a {text-decoration:none;}#yiv6806981338 dd.yiv6806981338last p a {font-family:Verdana;font-weight:700;}#yiv6806981338 dd.yiv6806981338last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6806981338 dd.yiv6806981338last p span.yiv6806981338yshortcuts {margin-right:0;}#yiv6806981338 div.yiv6806981338attach-table div div a {text-decoration:none;}#yiv6806981338 div.yiv6806981338attach-table {width:400px;}#yiv6806981338 div.yiv6806981338file-title a, #yiv6806981338 div.yiv6806981338file-title a:active, #yiv6806981338 div.yiv6806981338file-title a:hover, #yiv6806981338 div.yiv6806981338file-title a:visited {text-decoration:none;}#yiv6806981338 div.yiv6806981338photo-title a, #yiv6806981338 div.yiv6806981338photo-title a:active, #yiv6806981338 div.yiv6806981338photo-title a:hover, #yiv6806981338 div.yiv6806981338photo-title a:visited {text-decoration:none;}#yiv6806981338 div#yiv6806981338ygrp-mlmsg #yiv6806981338ygrp-msg p a span.yiv6806981338yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6806981338 .yiv6806981338green {color:#628c2a;}#yiv6806981338 .yiv6806981338MsoNormal {margin:0 0 0 0;}#yiv6806981338 o {font-size:0;}#yiv6806981338 #yiv6806981338photos div {float:left;width:72px;}#yiv6806981338 #yiv6806981338photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv6806981338 #yiv6806981338photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6806981338 #yiv6806981338reco-category {font-size:77%;}#yiv6806981338 #yiv6806981338reco-desc {font-size:77%;}#yiv6806981338 .yiv6806981338replbq {margin:4px;}#yiv6806981338 #yiv6806981338ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6806981338 #yiv6806981338ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6806981338 #yiv6806981338ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6806981338 #yiv6806981338ygrp-mlmsg select, #yiv6806981338 input, #yiv6806981338 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6806981338 #yiv6806981338ygrp-mlmsg pre, #yiv6806981338 code {font:115% monospace;}#yiv6806981338 #yiv6806981338ygrp-mlmsg * {line-height:1.22em;}#yiv6806981338 #yiv6806981338ygrp-mlmsg #yiv6806981338logo {padding-bottom:10px;}#yiv6806981338 #yiv6806981338ygrp-msg p a {font-family:Verdana;}#yiv6806981338 #yiv6806981338ygrp-msg p#yiv6806981338attach-count span {color:#1E66AE;font-weight:700;}#yiv6806981338 #yiv6806981338ygrp-reco #yiv6806981338reco-head {color:#ff7900;font-weight:700;}#yiv6806981338 #yiv6806981338ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6806981338 #yiv6806981338ygrp-sponsor #yiv6806981338ov li a {font-size:130%;text-decoration:none;}#yiv6806981338 #yiv6806981338ygrp-sponsor #yiv6806981338ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6806981338 #yiv6806981338ygrp-sponsor #yiv6806981338ov ul {margin:0;padding:0 0 0 8px;}#yiv6806981338 #yiv6806981338ygrp-text {font-family:Georgia;}#yiv6806981338 #yiv6806981338ygrp-text p {margin:0 0 1em 0;}#yiv6806981338 #yiv6806981338ygrp-text tt {font-size:120%;}#yiv6806981338 #yiv6806981338ygrp-vital ul li:last-child {border-right:none !important;}#yiv6806981338
Terimkasih atas infonya pak.. kalau regional settingnya ga dirubah emang ga bisa jalan formula DATEVALUEnya pak?? kebetulan seting regional pc saya harus english pak.
Pada Selasa, 28 Juli 2015 13:37, "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Hai Andree,Sdh cek regional settingnya ?
Salam,HK
----- Forwarded Message -----
From: "Andre Rahmaidy andree_bpdsumbar@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Tuesday, 28 July 2015, 13:02
Subject: [belajar-excel] Trs: Formula Format Tanggal
Dear Beexceller
terimakasih atas bantuan formulanya, cuma di ms office saya fungsi DATEVALUE kok berubah jadi eror ya seperti ini #value!..
Wassalam
Andree
#yiv6806981338 #yiv6806981338 -- #yiv6806981338ygrp-
Tue Jul 28, 2015 1:06 am (PDT) . Posted by:
"hendrik karnadi" hendrikkarnadi
Kalo seting reg pc nya English, tentu penulisan "Text" nya harus diubah dulu...bukan
| 04 JULI 1997 |
tetapi
| JULY 04, 1997 |
kalau format hasilnya mau tetap diperthankan sebagai data tanggal
Salam,HK
From: "Andre Rahmaidy andree_bpdsumbar@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Tuesday, 28 July 2015, 13:58
Subject: Bls: [belajar-excel] Trs: Formula Format Tanggal
Dear Pak Hendrik
Terimkasih atas infonya pak.. kalau regional settingnya ga dirubah emang ga bisa jalan formula DATEVALUEnya pak?? kebetulan seting regional pc saya harus english pak.
Pada Selasa, 28 Juli 2015 13:37, "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Hai Andree,Sdh cek regional settingnya ?
Salam,HK
----- Forwarded Message -----
From: "Andre Rahmaidy andree_bpdsumbar@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Tuesday, 28 July 2015, 13:02
Subject: [belajar-excel] Trs: Formula Format Tanggal
Dear Beexceller
terimakasih atas bantuan formulanya, cuma di ms office saya fungsi DATEVALUE kok berubah jadi eror ya seperti ini #value!..
Wassalam
Andree
#yiv5847203233 #yiv5847203233 -- #yiv5847203233ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5847203233 #yiv5847203233ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5847203233 #yiv5847203233ygrp-mkp #yiv5847203233hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5847203233 #yiv5847203233ygrp-mkp #yiv5847203233ads {margin-bottom:10px;}#yiv5847203233 #yiv5847203233ygrp-mkp .yiv5847203233ad {padding:0 0;}#yiv5847203233 #yiv5847203233ygrp-mkp .yiv5847203233ad p {margin:0;}#yiv5847203233 #yiv5847203233ygrp-mkp .yiv5847203233ad a {color:#0000ff;text-decoration:none;}#yiv5847203233 #yiv5847203233ygrp-sponsor #yiv5847203233ygrp-lc {font-family:Arial;}#yiv5847203233 #yiv5847203233ygrp-sponsor #yiv5847203233ygrp-lc #yiv5847203233hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5847203233 #yiv5847203233ygrp-sponsor #yiv5847203233ygrp-lc .yiv5847203233ad {margin-bottom:10px;padding:0 0;}#yiv5847203233 #yiv5847203233actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5847203233 #yiv5847203233activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5847203233 #yiv5847203233activity span {font-weight:700;}#yiv5847203233 #yiv5847203233activity span:first-child {text-transform:uppercase;}#yiv5847203233 #yiv5847203233activity span a {color:#5085b6;text-decoration:none;}#yiv5847203233 #yiv5847203233activity span span {color:#ff7900;}#yiv5847203233 #yiv5847203233activity span .yiv5847203233underline {text-decoration:underline;}#yiv5847203233 .yiv5847203233attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5847203233 .yiv5847203233attach div a {text-decoration:none;}#yiv5847203233 .yiv5847203233attach img {border:none;padding-right:5px;}#yiv5847203233 .yiv5847203233attach label {display:block;margin-bottom:5px;}#yiv5847203233 .yiv5847203233attach label a {text-decoration:none;}#yiv5847203233 blockquote {margin:0 0 0 4px;}#yiv5847203233 .yiv5847203233bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5847203233 .yiv5847203233bold a {text-decoration:none;}#yiv5847203233 dd.yiv5847203233last p a {font-family:Verdana;font-weight:700;}#yiv5847203233 dd.yiv5847203233last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5847203233 dd.yiv5847203233last p span.yiv5847203233yshortcuts {margin-right:0;}#yiv5847203233 div.yiv5847203233attach-table div div a {text-decoration:none;}#yiv5847203233 div.yiv5847203233attach-table {width:400px;}#yiv5847203233 div.yiv5847203233file-title a, #yiv5847203233 div.yiv5847203233file-title a:active, #yiv5847203233 div.yiv5847203233file-title a:hover, #yiv5847203233 div.yiv5847203233file-title a:visited {text-decoration:none;}#yiv5847203233 div.yiv5847203233photo-title a, #yiv5847203233 div.yiv5847203233photo-title a:active, #yiv5847203233 div.yiv5847203233photo-title a:hover, #yiv5847203233 div.yiv5847203233photo-title a:visited {text-decoration:none;}#yiv5847203233 div#yiv5847203233ygrp-mlmsg #yiv5847203233ygrp-msg p a span.yiv5847203233yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5847203233 .yiv5847203233green {color:#628c2a;}#yiv5847203233 .yiv5847203233MsoNormal {margin:0 0 0 0;}#yiv5847203233 o {font-size:0;}#yiv5847203233 #yiv5847203233photos div {float:left;width:72px;}#yiv5847203233 #yiv5847203233photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv5847203233 #yiv5847203233photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5847203233 #yiv5847203233reco-category {font-size:77%;}#yiv5847203233 #yiv5847203233reco-desc {font-size:77%;}#yiv5847203233 .yiv5847203233replbq {margin:4px;}#yiv5847203233 #yiv5847203233ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5847203233 #yiv5847203233ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5847203233 #yiv5847203233ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5847203233 #yiv5847203233ygrp-mlmsg select, #yiv5847203233 input, #yiv5847203233 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5847203233 #yiv5847203233ygrp-mlmsg pre, #yiv5847203233 code {font:115% monospace;}#yiv5847203233 #yiv5847203233ygrp-mlmsg * {line-height:1.22em;}#yiv5847203233 #yiv5847203233ygrp-mlmsg #yiv5847203233logo {padding-bottom:10px;}#yiv5847203233 #yiv5847203233ygrp-msg p a {font-family:Verdana;}#yiv5847203233 #yiv5847203233ygrp-msg p#yiv5847203233attach-count span {color:#1E66AE;font-weight:700;}#yiv5847203233 #yiv5847203233ygrp-reco #yiv5847203233reco-head {color:#ff7900;font-weight:700;}#yiv5847203233 #yiv5847203233ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5847203233 #yiv5847203233ygrp-sponsor #yiv5847203233ov li a {font-size:130%;text-decoration:none;}#yiv5847203233 #yiv5847203233ygrp-sponsor #yiv5847203233ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5847203233 #yiv5847203233ygrp-sponsor #yiv5847203233ov ul {margin:0;padding:0 0 0 8px;}#yiv5847203233 #yiv5847203233ygrp-text {font-family:Georgia;}#yiv5847203233 #yiv5847203233ygrp-text p {margin:0 0 1em 0;}#yiv5847203233 #yiv5847203233ygrp-text tt {font-size:120%;}#yiv5847203233 #yiv5847203233ygrp-vital ul li:last-child {border-right:none !important;}#yiv5847203233
| 04 JULI 1997 |
tetapi
| JULY 04, 1997 |
kalau format hasilnya mau tetap diperthankan sebagai data tanggal
Salam,HK
From: "Andre Rahmaidy andree_bpdsumbar@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Tuesday, 28 July 2015, 13:58
Subject: Bls: [belajar-excel] Trs: Formula Format Tanggal
Dear Pak Hendrik
Terimkasih atas infonya pak.. kalau regional settingnya ga dirubah emang ga bisa jalan formula DATEVALUEnya pak?? kebetulan seting regional pc saya harus english pak.
Pada Selasa, 28 Juli 2015 13:37, "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Hai Andree,Sdh cek regional settingnya ?
Salam,HK
----- Forwarded Message -----
From: "Andre Rahmaidy andree_bpdsumbar@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Tuesday, 28 July 2015, 13:02
Subject: [belajar-excel] Trs: Formula Format Tanggal
Dear Beexceller
terimakasih atas bantuan formulanya, cuma di ms office saya fungsi DATEVALUE kok berubah jadi eror ya seperti ini #value!..
Wassalam
Andree
#yiv5847203233 #yiv5847203233 -- #yiv5847203233ygrp-
Tue Jul 28, 2015 1:23 am (PDT) . Posted by:
"Kusnadi Bin zain" kbinzain
Dear : para pakar XL
Dengan hormat,
Bagaimana caranya menghilangkan Missing Eror seperti yg ada di lampiranyaitu Missing Eror : Microsoft Calendar Control 2007
Terima kasih dan maaf mungkin sebelumnya sdh pernah dibahas ...
Wassalam
Kusnadi
Dengan hormat,
Bagaimana caranya menghilangkan Missing Eror seperti yg ada di lampiranyaitu Missing Eror : Microsoft Calendar Control 2007
Terima kasih dan maaf mungkin sebelumnya sdh pernah dibahas ...
Wassalam
Kusnadi
============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------
Tidak ada komentar:
Posting Komentar