Kamis, 27 Agustus 2015

[belajar-excel] Digest Number 3548

7 Messages

Digest #3548

Messages

Wed Aug 26, 2015 6:39 am (PDT) . Posted by:

"Fajar Fatahillah" fajar.fatahillah

Dear Para Master Excel,
saya mau nanya masalah referensi formula, misal ada 2 file dalam satu folder
file A dan File B.
Didalam file A terdapat rumus / formula yang terhubung dengan file B.
Tapi tiba-tiba , formula di file A tersebut berubah lokasi filenya.
misalnya rumus di file A



='C:\data\[File B.xlsx]sheet1'!$H$3


tiba-tiba berubah ke


='C:\Users\NamaUser\AppData\Roaming\Microsoft\Excel\[File B.xlsx]sheet1'!$H$3


itu kenapa ya?


Mohon bantuannya



Terima Kasih







Best Regards, Fajar Fatahillah









Wed Aug 26, 2015 6:39 am (PDT) . Posted by:

"achmad adi" didon13@ymail.com

terimakasih Mr toby..sebelumnyatapi sepertinya terlalu banayk perintah ya,,hehehehe...maksd q bisa gk dibuat yan lebih simple,,biar bisa belajar rumusnya..
seperti ini ni,,nemu di file milis punya Alm Bu siti
dan saya kembangkan,,mentok,,untuk keterangan namanya,,mohon bantuanya

Pada Senin, 24 Agustus 2015 0:25, "Toby kenzo tobykenzo@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


 
| Dear Didon,File berikut menggunakan VBA untuk valudasi bertingkat dngan menggunakan ComboBox.Semoga bisa membantu.
It's work in Office 2013.
TerimaKasih.Sent from Yahoo Mail on Android |

From: achmad adi didon13@ymail.com [belajar-excel] <belajar-excel@yahoogroups.com>;
To: <belajar-excel@yahoogroups.com>;
Subject: [belajar-excel] valdasi bertingkat modif [1 Attachment]
Sent: Thu, Aug 20, 2015 3:00:27 AM


|  
dear master,,mohon bantuanyautnuk masalah yang saya hadapi,,mengambil dari validasi bertingkat di file mail archive BE,,,saya mau memodifikasi perintah masalah validasi bertingkat,,mohon pencerahaannya,,,ini saya lampirkan file contohnya..
sebelumnya saya ucapkan terima kasih |

#yiv6913246463 #yiv6913246463 -- #yiv6913246463ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6913246463 #yiv6913246463ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6913246463 #yiv6913246463ygrp-mkp #yiv6913246463hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6913246463 #yiv6913246463ygrp-mkp #yiv6913246463ads {margin-bottom:10px;}#yiv6913246463 #yiv6913246463ygrp-mkp .yiv6913246463ad {padding:0 0;}#yiv6913246463 #yiv6913246463ygrp-mkp .yiv6913246463ad p {margin:0;}#yiv6913246463 #yiv6913246463ygrp-mkp .yiv6913246463ad a {color:#0000ff;text-decoration:none;}#yiv6913246463 #yiv6913246463ygrp-sponsor #yiv6913246463ygrp-lc {font-family:Arial;}#yiv6913246463 #yiv6913246463ygrp-sponsor #yiv6913246463ygrp-lc #yiv6913246463hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6913246463 #yiv6913246463ygrp-sponsor #yiv6913246463ygrp-lc .yiv6913246463ad {margin-bottom:10px;padding:0 0;}#yiv6913246463 #yiv6913246463actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6913246463 #yiv6913246463activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6913246463 #yiv6913246463activity span {font-weight:700;}#yiv6913246463 #yiv6913246463activity span:first-child {text-transform:uppercase;}#yiv6913246463 #yiv6913246463activity span a {color:#5085b6;text-decoration:none;}#yiv6913246463 #yiv6913246463activity span span {color:#ff7900;}#yiv6913246463 #yiv6913246463activity span .yiv6913246463underline {text-decoration:underline;}#yiv6913246463 .yiv6913246463attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6913246463 .yiv6913246463attach div a {text-decoration:none;}#yiv6913246463 .yiv6913246463attach img {border:none;padding-right:5px;}#yiv6913246463 .yiv6913246463attach label {display:block;margin-bottom:5px;}#yiv6913246463 .yiv6913246463attach label a {text-decoration:none;}#yiv6913246463 blockquote {margin:0 0 0 4px;}#yiv6913246463 .yiv6913246463bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6913246463 .yiv6913246463bold a {text-decoration:none;}#yiv6913246463 dd.yiv6913246463last p a {font-family:Verdana;font-weight:700;}#yiv6913246463 dd.yiv6913246463last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6913246463 dd.yiv6913246463last p span.yiv6913246463yshortcuts {margin-right:0;}#yiv6913246463 div.yiv6913246463attach-table div div a {text-decoration:none;}#yiv6913246463 div.yiv6913246463attach-table {width:400px;}#yiv6913246463 div.yiv6913246463file-title a, #yiv6913246463 div.yiv6913246463file-title a:active, #yiv6913246463 div.yiv6913246463file-title a:hover, #yiv6913246463 div.yiv6913246463file-title a:visited {text-decoration:none;}#yiv6913246463 div.yiv6913246463photo-title a, #yiv6913246463 div.yiv6913246463photo-title a:active, #yiv6913246463 div.yiv6913246463photo-title a:hover, #yiv6913246463 div.yiv6913246463photo-title a:visited {text-decoration:none;}#yiv6913246463 div#yiv6913246463ygrp-mlmsg #yiv6913246463ygrp-msg p a span.yiv6913246463yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6913246463 .yiv6913246463green {color:#628c2a;}#yiv6913246463 .yiv6913246463MsoNormal {margin:0 0 0 0;}#yiv6913246463 o {font-size:0;}#yiv6913246463 #yiv6913246463photos div {float:left;width:72px;}#yiv6913246463 #yiv6913246463photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv6913246463 #yiv6913246463photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6913246463 #yiv6913246463reco-category {font-size:77%;}#yiv6913246463 #yiv6913246463reco-desc {font-size:77%;}#yiv6913246463 .yiv6913246463replbq {margin:4px;}#yiv6913246463 #yiv6913246463ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6913246463 #yiv6913246463ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6913246463 #yiv6913246463ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6913246463 #yiv6913246463ygrp-mlmsg select, #yiv6913246463 input, #yiv6913246463 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6913246463 #yiv6913246463ygrp-mlmsg pre, #yiv6913246463 code {font:115% monospace;}#yiv6913246463 #yiv6913246463ygrp-mlmsg * {line-height:1.22em;}#yiv6913246463 #yiv6913246463ygrp-mlmsg #yiv6913246463logo {padding-bottom:10px;}#yiv6913246463 #yiv6913246463ygrp-msg p a {font-family:Verdana;}#yiv6913246463 #yiv6913246463ygrp-msg p#yiv6913246463attach-count span {color:#1E66AE;font-weight:700;}#yiv6913246463 #yiv6913246463ygrp-reco #yiv6913246463reco-head {color:#ff7900;font-weight:700;}#yiv6913246463 #yiv6913246463ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6913246463 #yiv6913246463ygrp-sponsor #yiv6913246463ov li a {font-size:130%;text-decoration:none;}#yiv6913246463 #yiv6913246463ygrp-sponsor #yiv6913246463ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6913246463 #yiv6913246463ygrp-sponsor #yiv6913246463ov ul {margin:0;padding:0 0 0 8px;}#yiv6913246463 #yiv6913246463ygrp-text {font-family:Georgia;}#yiv6913246463 #yiv6913246463ygrp-text p {margin:0 0 1em 0;}#yiv6913246463 #yiv6913246463ygrp-text tt {font-size:120%;}#yiv6913246463 #yiv6913246463ygrp-vital ul li:last-child {border-right:none !important;}#yiv6913246463

Wed Aug 26, 2015 10:30 am (PDT) . Posted by:

"Toby kenzo" tobykenzo

Dear Didon,

Pada inti sama,yg membedakan hanya menggunakan userform.
Jika kamu memahami konsep kaidah database,kamu bisa buat dalam bentuk apapun yg diinginkan,mungkin sedikit usaha dan kerja keras untuk lebih memahami VBA kmu bisa create sendiri tanpa meniru milik siapapun.

TerimaKasih.

Sent from Yahoo Mail on Android

Wed Aug 26, 2015 6:40 am (PDT) . Posted by:

fathianm

Mohon bantuan members sekalian. file terlampir

Wed Aug 26, 2015 6:40 am (PDT) . Posted by:

"iskandar just" i5mudh_782

Salam BeExcel yang terhormat...Mohon bantuan formula excel untuk autofill dari dua sheet sumber data ke sheet lain sebagai sheet hasil sesuai kriteria tertentu.Secara garis besar terdapat 2 (dua) sheet sebagai sumber data, lalu di sheet lainnya merupakan sheet hasil yang diinginkan dengan kriteria tertentu.Untuk lebih to the case, terlampir file kertas kerja yang dimaksud.Atas bantuan teman-teman dan master BeExcel, terlebih dahulu saya ucapkan terima kasih.

Wed Aug 26, 2015 6:41 am (PDT) . Posted by:

"Liem Suliem" liemsuliem

dhdear pak toby dan rekan be excel
saya juga mempunyai kasus yang hampir mirip..tapi saya coba makro dari pak toby.. misal nya data lebih banyak kok belum sesuai ya..ini kan data nya sampai baris 449 tapi seandainya data sampai baris 600.baris yang ke 450 samapi 600 tdak ikut di eksekusi.

salam
liem


Pada Senin, 17 Agustus 2015 16:47, "Toby kenzo tobykenzo@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


 
| Dear Ratri,Mungkin file ini bisa membantu.It's work in Office 2013.TerimaKasih.Sent from Yahoo Mail on Android |

From: Ratri Risyanto ratrisyanto@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com>;
To: <belajar-excel@yahoogroups.com>;
Subject: [belajar-excel] Loop tidak bisa berhenti [1 Attachment]
Sent: Sun, Aug 16, 2015 12:31:34 PM


|   Dear all masterSaya mau meringkas data dg menghapus header hasil dr convert pdf ke excel.. namun kendalanya macro saya loop tidak bisa berhenti..Data terlampir:
Sheet AWAL merupakan data yg akan diproses
Sheet HASIL merupakan data hasil setelah proses (ini saya proses manual)
Macro ada di module1Mohon bantuannya agar macronya bisa berjalan dan berhenti otomatis dan hasilnya sesuai sheet HASIL.Terima kasih
Risyanto |

#yiv5127193844 #yiv5127193844 -- #yiv5127193844ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5127193844 #yiv5127193844ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5127193844 #yiv5127193844ygrp-mkp #yiv5127193844hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5127193844 #yiv5127193844ygrp-mkp #yiv5127193844ads {margin-bottom:10px;}#yiv5127193844 #yiv5127193844ygrp-mkp .yiv5127193844ad {padding:0 0;}#yiv5127193844 #yiv5127193844ygrp-mkp .yiv5127193844ad p {margin:0;}#yiv5127193844 #yiv5127193844ygrp-mkp .yiv5127193844ad a {color:#0000ff;text-decoration:none;}#yiv5127193844 #yiv5127193844ygrp-sponsor #yiv5127193844ygrp-lc {font-family:Arial;}#yiv5127193844 #yiv5127193844ygrp-sponsor #yiv5127193844ygrp-lc #yiv5127193844hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5127193844 #yiv5127193844ygrp-sponsor #yiv5127193844ygrp-lc .yiv5127193844ad {margin-bottom:10px;padding:0 0;}#yiv5127193844 #yiv5127193844actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5127193844 #yiv5127193844activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5127193844 #yiv5127193844activity span {font-weight:700;}#yiv5127193844 #yiv5127193844activity span:first-child {text-transform:uppercase;}#yiv5127193844 #yiv5127193844activity span a {color:#5085b6;text-decoration:none;}#yiv5127193844 #yiv5127193844activity span span {color:#ff7900;}#yiv5127193844 #yiv5127193844activity span .yiv5127193844underline {text-decoration:underline;}#yiv5127193844 .yiv5127193844attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5127193844 .yiv5127193844attach div a {text-decoration:none;}#yiv5127193844 .yiv5127193844attach img {border:none;padding-right:5px;}#yiv5127193844 .yiv5127193844attach label {display:block;margin-bottom:5px;}#yiv5127193844 .yiv5127193844attach label a {text-decoration:none;}#yiv5127193844 blockquote {margin:0 0 0 4px;}#yiv5127193844 .yiv5127193844bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5127193844 .yiv5127193844bold a {text-decoration:none;}#yiv5127193844 dd.yiv5127193844last p a {font-family:Verdana;font-weight:700;}#yiv5127193844 dd.yiv5127193844last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5127193844 dd.yiv5127193844last p span.yiv5127193844yshortcuts {margin-right:0;}#yiv5127193844 div.yiv5127193844attach-table div div a {text-decoration:none;}#yiv5127193844 div.yiv5127193844attach-table {width:400px;}#yiv5127193844 div.yiv5127193844file-title a, #yiv5127193844 div.yiv5127193844file-title a:active, #yiv5127193844 div.yiv5127193844file-title a:hover, #yiv5127193844 div.yiv5127193844file-title a:visited {text-decoration:none;}#yiv5127193844 div.yiv5127193844photo-title a, #yiv5127193844 div.yiv5127193844photo-title a:active, #yiv5127193844 div.yiv5127193844photo-title a:hover, #yiv5127193844 div.yiv5127193844photo-title a:visited {text-decoration:none;}#yiv5127193844 div#yiv5127193844ygrp-mlmsg #yiv5127193844ygrp-msg p a span.yiv5127193844yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5127193844 .yiv5127193844green {color:#628c2a;}#yiv5127193844 .yiv5127193844MsoNormal {margin:0 0 0 0;}#yiv5127193844 o {font-size:0;}#yiv5127193844 #yiv5127193844photos div {float:left;width:72px;}#yiv5127193844 #yiv5127193844photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv5127193844 #yiv5127193844photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5127193844 #yiv5127193844reco-category {font-size:77%;}#yiv5127193844 #yiv5127193844reco-desc {font-size:77%;}#yiv5127193844 .yiv5127193844replbq {margin:4px;}#yiv5127193844 #yiv5127193844ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5127193844 #yiv5127193844ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5127193844 #yiv5127193844ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5127193844 #yiv5127193844ygrp-mlmsg select, #yiv5127193844 input, #yiv5127193844 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5127193844 #yiv5127193844ygrp-mlmsg pre, #yiv5127193844 code {font:115% monospace;}#yiv5127193844 #yiv5127193844ygrp-mlmsg * {line-height:1.22em;}#yiv5127193844 #yiv5127193844ygrp-mlmsg #yiv5127193844logo {padding-bottom:10px;}#yiv5127193844 #yiv5127193844ygrp-msg p a {font-family:Verdana;}#yiv5127193844 #yiv5127193844ygrp-msg p#yiv5127193844attach-count span {color:#1E66AE;font-weight:700;}#yiv5127193844 #yiv5127193844ygrp-reco #yiv5127193844reco-head {color:#ff7900;font-weight:700;}#yiv5127193844 #yiv5127193844ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5127193844 #yiv5127193844ygrp-sponsor #yiv5127193844ov li a {font-size:130%;text-decoration:none;}#yiv5127193844 #yiv5127193844ygrp-sponsor #yiv5127193844ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5127193844 #yiv5127193844ygrp-sponsor #yiv5127193844ov ul {margin:0;padding:0 0 0 8px;}#yiv5127193844 #yiv5127193844ygrp-text {font-family:Georgia;}#yiv5127193844 #yiv5127193844ygrp-text p {margin:0 0 1em 0;}#yiv5127193844 #yiv5127193844ygrp-text tt {font-size:120%;}#yiv5127193844 #yiv5127193844ygrp-vital ul li:last-child {border-right:none !important;}#yiv5127193844

Wed Aug 26, 2015 10:13 am (PDT) . Posted by:

"Toby kenzo" tobykenzo

Dear Liem,

Coba kamu lihat lagi programnya,program yg di buat hanya terbatas untuk 192cell, jika mau di tambahkan,bisa saja di tambahkan dgn mengganti nilai H200 ke nilai yg diinginkan,bisa jg memanfaatkan pembuatan formula pd name manager.

TerimaKasih.

Sent from Yahoo Mail on Android

============================================================
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