Dear Mr. Kenzoterima kasih banyak untuk opsi solusi dengan menggunakan
VBA.terus terang saya masih sangat awan untuk konsep VBA, tapi saya yakin akan
jadi referensi berguna untuk kedepannya.saya akan pelajari lagi terlebih
dahulu.sekali lagi terima kasih banyak Mr. Kenzo
Thanks,Kurniadi Raha
Pada Kamis, 4 Juni 2015 11:30, "Toby kenzo [email protected]
[belajar-excel]" <[email protected]> menulis:
Dear Raha, Berikut contoh dengan menggunakan VBA. TerimaKasih.
Pada Kamis, 4 Juni 2015 9:39, "kurniadi raha [email protected]
[belajar-excel]" <[email protected]> menulis:
Hai Pak Mr. Kidterima kasih sekali atas solusi yang diberikan.walaupun
saya belum paham sepenuhnya dari rumus yang diberikan, tapi secara general apa
yang saya minta sudah terjawab :) saya akan pelajari lagi dulu dan apabila ada
yang perlu ditanyakan saya akan informasikan lagi.sekali lagi saya ucapkan
terima kasih.
-Kurniadi Raha-
Pada Rabu, 3 Juni 2015 20:01, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> menulis:
Hai Kurniadi Raha,
Tampaknya akan lebiih mudah jika memiliki sebuah tabel yang baik berisi daftar
material setiap menu.
Pada file terlampir, tabel ini dapat dilihat di sheet bernama
'ref_material_menu' dari kolom A sampai kolom F
Dari tabel tersebut, maka proses pengolahan data menjadi output akan lebih
mudah dan memiliki banyak opsi. Contohnya pada file-file terlampir.
Regard,
Kid
2015-06-03 18:51 GMT+10:00 kurniadi raha [email protected]
[belajar-excel] <[email protected]>:
Dear teman-teman komunitas milis belajar excel, mohon bantu concern
sayaberikut terkait breakdown material. saya memiliki list menumakanan dan
kemudian saya mau apabila qty menu makanan diisikan maka listmaterial akan
otomatis terisi dengan database qty yang sudah saya tentukan.untuk lebih jelas
mohoncek file terlampir. Atas perhatian dan solusiyang diberikan saya ucapkan
banyak terima kasih.
regards,kurniadi raha
#yiv0695934776 #yiv0695934776 -- #yiv0695934776ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0695934776
#yiv0695934776ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0695934776
#yiv0695934776ygrp-mkp #yiv0695934776hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0695934776 #yiv0695934776ygrp-mkp #yiv0695934776ads
{margin-bottom:10px;}#yiv0695934776 #yiv0695934776ygrp-mkp .yiv0695934776ad
{padding:0 0;}#yiv0695934776 #yiv0695934776ygrp-mkp .yiv0695934776ad p
{margin:0;}#yiv0695934776 #yiv0695934776ygrp-mkp .yiv0695934776ad a
{color:#0000ff;text-decoration:none;}#yiv0695934776 #yiv0695934776ygrp-sponsor
#yiv0695934776ygrp-lc {font-family:Arial;}#yiv0695934776
#yiv0695934776ygrp-sponsor #yiv0695934776ygrp-lc #yiv0695934776hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0695934776
#yiv0695934776ygrp-sponsor #yiv0695934776ygrp-lc .yiv0695934776ad
{margin-bottom:10px;padding:0 0;}#yiv0695934776 #yiv0695934776actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0695934776
#yiv0695934776activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0695934776
#yiv0695934776activity span {font-weight:700;}#yiv0695934776
#yiv0695934776activity span:first-child
{text-transform:uppercase;}#yiv0695934776 #yiv0695934776activity span a
{color:#5085b6;text-decoration:none;}#yiv0695934776 #yiv0695934776activity span
span {color:#ff7900;}#yiv0695934776 #yiv0695934776activity span
.yiv0695934776underline {text-decoration:underline;}#yiv0695934776
.yiv0695934776attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0695934776 .yiv0695934776attach div a
{text-decoration:none;}#yiv0695934776 .yiv0695934776attach img
{border:none;padding-right:5px;}#yiv0695934776 .yiv0695934776attach label
{display:block;margin-bottom:5px;}#yiv0695934776 .yiv0695934776attach label a
{text-decoration:none;}#yiv0695934776 blockquote {margin:0 0 0
4px;}#yiv0695934776 .yiv0695934776bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0695934776
.yiv0695934776bold a {text-decoration:none;}#yiv0695934776 dd.yiv0695934776last
p a {font-family:Verdana;font-weight:700;}#yiv0695934776 dd.yiv0695934776last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0695934776
dd.yiv0695934776last p span.yiv0695934776yshortcuts
{margin-right:0;}#yiv0695934776 div.yiv0695934776attach-table div div a
{text-decoration:none;}#yiv0695934776 div.yiv0695934776attach-table
{width:400px;}#yiv0695934776 div.yiv0695934776file-title a, #yiv0695934776
div.yiv0695934776file-title a:active, #yiv0695934776
div.yiv0695934776file-title a:hover, #yiv0695934776 div.yiv0695934776file-title
a:visited {text-decoration:none;}#yiv0695934776 div.yiv0695934776photo-title a,
#yiv0695934776 div.yiv0695934776photo-title a:active, #yiv0695934776
div.yiv0695934776photo-title a:hover, #yiv0695934776
div.yiv0695934776photo-title a:visited {text-decoration:none;}#yiv0695934776
div#yiv0695934776ygrp-mlmsg #yiv0695934776ygrp-msg p a
span.yiv0695934776yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0695934776
.yiv0695934776green {color:#628c2a;}#yiv0695934776 .yiv0695934776MsoNormal
{margin:0 0 0 0;}#yiv0695934776 o {font-size:0;}#yiv0695934776
#yiv0695934776photos div {float:left;width:72px;}#yiv0695934776
#yiv0695934776photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv0695934776
#yiv0695934776photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0695934776
#yiv0695934776reco-category {font-size:77%;}#yiv0695934776
#yiv0695934776reco-desc {font-size:77%;}#yiv0695934776 .yiv0695934776replbq
{margin:4px;}#yiv0695934776 #yiv0695934776ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0695934776 #yiv0695934776ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0695934776
#yiv0695934776ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0695934776
#yiv0695934776ygrp-mlmsg select, #yiv0695934776 input, #yiv0695934776 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0695934776
#yiv0695934776ygrp-mlmsg pre, #yiv0695934776 code {font:115%
monospace;}#yiv0695934776 #yiv0695934776ygrp-mlmsg *
{line-height:1.22em;}#yiv0695934776 #yiv0695934776ygrp-mlmsg #yiv0695934776logo
{padding-bottom:10px;}#yiv0695934776 #yiv0695934776ygrp-msg p a
{font-family:Verdana;}#yiv0695934776 #yiv0695934776ygrp-msg
p#yiv0695934776attach-count span {color:#1E66AE;font-weight:700;}#yiv0695934776
#yiv0695934776ygrp-reco #yiv0695934776reco-head
{color:#ff7900;font-weight:700;}#yiv0695934776 #yiv0695934776ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv0695934776 #yiv0695934776ygrp-sponsor
#yiv0695934776ov li a {font-size:130%;text-decoration:none;}#yiv0695934776
#yiv0695934776ygrp-sponsor #yiv0695934776ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0695934776
#yiv0695934776ygrp-sponsor #yiv0695934776ov ul {margin:0;padding:0 0 0
8px;}#yiv0695934776 #yiv0695934776ygrp-text
{font-family:Georgia;}#yiv0695934776 #yiv0695934776ygrp-text p {margin:0 0 1em
0;}#yiv0695934776 #yiv0695934776ygrp-text tt {font-size:120%;}#yiv0695934776
#yiv0695934776ygrp-vital ul li:last-child {border-right:none
!important;}#yiv0695934776
