[belajar-excel] Form Copy Paste [1 Attachment]

classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] Form Copy Paste [1 Attachment]

Syahri

Mohon maaf para Suhu. Apa bisa dibuatkan macro untuk menjalankan form seperti pada gambar? Terima kasih

Dikirim dari Yahoo Mail di Android

IMG_20200530_193346_155.jpg (156K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Form Copy Paste [1 Attachment]

hendrik karnadi
 Prinsipnya bisa.Coba kirim Dummy Sheets inputnya dan Output yang diinginkan.
Salam,HK

    On Saturday, 30 May 2020, 06:36:16 pm GMT+7, syahri indonesia [hidden email] [belajar-excel] <[hidden email]> wrote:  
 
    


Mohon maaf para Suhu. Apa bisa dibuatkan macro untuk menjalankan form seperti pada gambar? Terima kasih

Dikirim dari Yahoo Mail di Android    

IMG_20200530_193346_155.jpg (156K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Balas: Re: [belajar-excel] Form Copy Paste [3 Attachments]

Syahri
Contoh file dummy

Dikirim dari Yahoo Mail di Android
 
  Pada Sab, 30 Mei 2020 pada 21:35, hendrik karnadi [hidden email] [belajar-excel]<[hidden email]> menulis:      

 Prinsipnya bisa.Coba kirim Dummy Sheets inputnya dan Output yang diinginkan.
Salam,HK

    On Saturday, 30 May 2020, 06:36:16 pm GMT+7, syahri indonesia [hidden email] [belajar-excel] <[hidden email]> wrote:  
 
    


Mohon maaf para Suhu. Apa bisa dibuatkan macro untuk menjalankan form seperti pada gambar? Terima kasih

Dikirim dari Yahoo Mail di Android      #yiv2183468497 -- #yiv2183468497ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2183468497 #yiv2183468497ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2183468497 #yiv2183468497ygrp-mkp #yiv2183468497hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2183468497 #yiv2183468497ygrp-mkp #yiv2183468497ads {margin-bottom:10px;}#yiv2183468497 #yiv2183468497ygrp-mkp .yiv2183468497ad {padding:0 0;}#yiv2183468497 #yiv2183468497ygrp-mkp .yiv2183468497ad p {margin:0;}#yiv2183468497 #yiv2183468497ygrp-mkp .yiv2183468497ad a {color:#0000ff;text-decoration:none;}#yiv2183468497 #yiv2183468497ygrp-sponsor #yiv2183468497ygrp-lc {font-family:Arial;}#yiv2183468497 #yiv2183468497ygrp-sponsor #yiv2183468497ygrp-lc #yiv2183468497hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2183468497 #yiv2183468497ygrp-sponsor #yiv2183468497ygrp-lc .yiv2183468497ad {margin-bottom:10px;padding:0 0;}#yiv2183468497 #yiv2183468497actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2183468497 #yiv2183468497activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2183468497 #yiv2183468497activity span {font-weight:700;}#yiv2183468497 #yiv2183468497activity span:first-child {text-transform:uppercase;}#yiv2183468497 #yiv2183468497activity span a {color:#5085b6;text-decoration:none;}#yiv2183468497 #yiv2183468497activity span span {color:#ff7900;}#yiv2183468497 #yiv2183468497activity span .yiv2183468497underline {text-decoration:underline;}#yiv2183468497 .yiv2183468497attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2183468497 .yiv2183468497attach div a {text-decoration:none;}#yiv2183468497 .yiv2183468497attach img {border:none;padding-right:5px;}#yiv2183468497 .yiv2183468497attach label {display:block;margin-bottom:5px;}#yiv2183468497 .yiv2183468497attach label a {text-decoration:none;}#yiv2183468497 blockquote {margin:0 0 0 4px;}#yiv2183468497 .yiv2183468497bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2183468497 .yiv2183468497bold a {text-decoration:none;}#yiv2183468497 dd.yiv2183468497last p a {font-family:Verdana;font-weight:700;}#yiv2183468497 dd.yiv2183468497last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2183468497 dd.yiv2183468497last p span.yiv2183468497yshortcuts {margin-right:0;}#yiv2183468497 div..yiv2183468497attach-table div div a {text-decoration:none;}#yiv2183468497 div.yiv2183468497attach-table {width:400px;}#yiv2183468497 div.yiv2183468497file-title a, #yiv2183468497 div.yiv2183468497file-title a:active, #yiv2183468497 div.yiv2183468497file-title a:hover, #yiv2183468497 div.yiv2183468497file-title a:visited {text-decoration:none;}#yiv2183468497 div.yiv2183468497photo-title a, #yiv2183468497 div.yiv2183468497photo-title a:active, #yiv2183468497 div.yiv2183468497photo-title a:hover, #yiv2183468497 div.yiv2183468497photo-title a:visited {text-decoration:none;}#yiv2183468497 div#yiv2183468497ygrp-mlmsg #yiv2183468497ygrp-msg p a span.yiv2183468497yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2183468497 .yiv2183468497green {color:#628c2a;}#yiv2183468497 .yiv2183468497MsoNormal {margin:0 0 0 0;}#yiv2183468497 o {font-size:0;}#yiv2183468497 #yiv2183468497photos div {float:left;width:72px;}#yiv2183468497 #yiv2183468497photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv2183468497 #yiv2183468497photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2183468497 #yiv2183468497reco-category {font-size:77%;}#yiv2183468497 #yiv2183468497reco-desc {font-size:77%;}#yiv2183468497 .yiv2183468497replbq {margin:4px;}#yiv2183468497 #yiv2183468497ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2183468497 #yiv2183468497ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2183468497 #yiv2183468497ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2183468497 #yiv2183468497ygrp-mlmsg select, #yiv2183468497 input, #yiv2183468497 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2183468497 #yiv2183468497ygrp-mlmsg pre, #yiv2183468497 code {font:115% monospace;}#yiv2183468497 #yiv2183468497ygrp-mlmsg * {line-height:1.22em;}#yiv2183468497 #yiv2183468497ygrp-mlmsg #yiv2183468497logo {padding-bottom:10px;}#yiv2183468497 #yiv2183468497ygrp-msg p a {font-family:Verdana;}#yiv2183468497 #yiv2183468497ygrp-msg p#yiv2183468497attach-count span {color:#1E66AE;font-weight:700;}#yiv2183468497 #yiv2183468497ygrp-reco #yiv2183468497reco-head {color:#ff7900;font-weight:700;}#yiv2183468497 #yiv2183468497ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2183468497 #yiv2183468497ygrp-sponsor #yiv2183468497ov li a {font-size:130%;text-decoration:none;}#yiv2183468497 #yiv2183468497ygrp-sponsor #yiv2183468497ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2183468497 #yiv2183468497ygrp-sponsor #yiv2183468497ov ul {margin:0;padding:0 0 0 8px;}#yiv2183468497 #yiv2183468497ygrp-text {font-family:Georgia;}#yiv2183468497 #yiv2183468497ygrp-text p {margin:0 0 1em 0;}#yiv2183468497 #yiv2183468497ygrp-text tt {font-size:120%;}#yiv2183468497 #yiv2183468497ygrp-vital ul li:last-child {border-right:none !important;}#yiv2183468497  

Source File.xlsx (22K) Download Attachment
Target File.xlsx (16K) Download Attachment
IMG_20200530_193346_155.jpg (156K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Balas: Re: [belajar-excel] Form Copy Paste [1 Attachment]

Aan Hasanudin Aan
https://youtu.be/U4TjSaOOn6EBantu share dan Subscribe 

Sent from Yahoo Mail on Android
 
  On Sat, May 30, 2020 at 21:27, syahri indonesia [hidden email] [belajar-excel]<[hidden email]> wrote:      

Contoh file dummy

Dikirim dari Yahoo Mail di Android
 
  Pada Sab, 30 Mei 2020 pada 21:35, hendrik karnadi [hidden email] [belajar-excel]<[hidden email]> menulis:      

 Prinsipnya bisa.Coba kirim Dummy Sheets inputnya dan Output yang diinginkan.
Salam,HK

    On Saturday, 30 May 2020, 06:36:16 pm GMT+7, syahri indonesia [hidden email] [belajar-excel] <[hidden email]> wrote:  
 
    


Mohon maaf para Suhu. Apa bisa dibuatkan macro untuk menjalankan form seperti pada gambar? Terima kasih

Dikirim dari Yahoo Mail di Android        
  #yiv2036139967 #yiv2036139967 -- #yiv2036139967ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2036139967 #yiv2036139967ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2036139967 #yiv2036139967ygrp-mkp #yiv2036139967hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2036139967 #yiv2036139967ygrp-mkp #yiv2036139967ads {margin-bottom:10px;}#yiv2036139967 #yiv2036139967ygrp-mkp .yiv2036139967ad {padding:0 0;}#yiv2036139967 #yiv2036139967ygrp-mkp .yiv2036139967ad p {margin:0;}#yiv2036139967 #yiv2036139967ygrp-mkp .yiv2036139967ad a {color:#0000ff;text-decoration:none;}#yiv2036139967 #yiv2036139967ygrp-sponsor #yiv2036139967ygrp-lc {font-family:Arial;}#yiv2036139967 #yiv2036139967ygrp-sponsor #yiv2036139967ygrp-lc #yiv2036139967hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2036139967 #yiv2036139967ygrp-sponsor #yiv2036139967ygrp-lc .yiv2036139967ad {margin-bottom:10px;padding:0 0;}#yiv2036139967 #yiv2036139967actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2036139967 #yiv2036139967activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2036139967 #yiv2036139967activity span {font-weight:700;}#yiv2036139967 #yiv2036139967activity span:first-child {text-transform:uppercase;}#yiv2036139967 #yiv2036139967activity span a {color:#5085b6;text-decoration:none;}#yiv2036139967 #yiv2036139967activity span span {color:#ff7900;}#yiv2036139967 #yiv2036139967activity span .yiv2036139967underline {text-decoration:underline;}#yiv2036139967 .yiv2036139967attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2036139967 .yiv2036139967attach div a {text-decoration:none;}#yiv2036139967 .yiv2036139967attach img {border:none;padding-right:5px;}#yiv2036139967 .yiv2036139967attach label {display:block;margin-bottom:5px;}#yiv2036139967 .yiv2036139967attach label a {text-decoration:none;}#yiv2036139967 blockquote {margin:0 0 0 4px;}#yiv2036139967 .yiv2036139967bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2036139967 .yiv2036139967bold a {text-decoration:none;}#yiv2036139967 dd.yiv2036139967last p a {font-family:Verdana;font-weight:700;}#yiv2036139967 dd.yiv2036139967last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2036139967 dd.yiv2036139967last p span.yiv2036139967yshortcuts {margin-right:0;}#yiv2036139967 div.yiv2036139967attach-table div div a {text-decoration:none;}#yiv2036139967 div.yiv2036139967attach-table {width:400px;}#yiv2036139967 div.yiv2036139967file-title a, #yiv2036139967 div.yiv2036139967file-title a:active, #yiv2036139967 div.yiv2036139967file-title a:hover, #yiv2036139967 div.yiv2036139967file-title a:visited {text-decoration:none;}#yiv2036139967 div.yiv2036139967photo-title a, #yiv2036139967 div.yiv2036139967photo-title a:active, #yiv2036139967 div.yiv2036139967photo-title a:hover, #yiv2036139967 div.yiv2036139967photo-title a:visited {text-decoration:none;}#yiv2036139967 div#yiv2036139967ygrp-mlmsg #yiv2036139967ygrp-msg p a span.yiv2036139967yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2036139967 .yiv2036139967green {color:#628c2a;}#yiv2036139967 .yiv2036139967MsoNormal {margin:0 0 0 0;}#yiv2036139967 o {font-size:0;}#yiv2036139967 #yiv2036139967photos div {float:left;width:72px;}#yiv2036139967 #yiv2036139967photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv2036139967 #yiv2036139967photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2036139967 #yiv2036139967reco-category {font-size:77%;}#yiv2036139967 #yiv2036139967reco-desc {font-size:77%;}#yiv2036139967 .yiv2036139967replbq {margin:4px;}#yiv2036139967 #yiv2036139967ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2036139967 #yiv2036139967ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2036139967 #yiv2036139967ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2036139967 #yiv2036139967ygrp-mlmsg select, #yiv2036139967 input, #yiv2036139967 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2036139967 #yiv2036139967ygrp-mlmsg pre, #yiv2036139967 code {font:115% monospace;}#yiv2036139967 #yiv2036139967ygrp-mlmsg * {line-height:1.22em;}#yiv2036139967 #yiv2036139967ygrp-mlmsg #yiv2036139967logo {padding-bottom:10px;}#yiv2036139967 #yiv2036139967ygrp-msg p a {font-family:Verdana;}#yiv2036139967 #yiv2036139967ygrp-msg p#yiv2036139967attach-count span {color:#1E66AE;font-weight:700;}#yiv2036139967 #yiv2036139967ygrp-reco #yiv2036139967reco-head {color:#ff7900;font-weight:700;}#yiv2036139967 #yiv2036139967ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2036139967 #yiv2036139967ygrp-sponsor #yiv2036139967ov li a {font-size:130%;text-decoration:none;}#yiv2036139967 #yiv2036139967ygrp-sponsor #yiv2036139967ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2036139967 #yiv2036139967ygrp-sponsor #yiv2036139967ov ul {margin:0;padding:0 0 0 8px;}#yiv2036139967 #yiv2036139967ygrp-text {font-family:Georgia;}#yiv2036139967 #yiv2036139967ygrp-text p {margin:0 0 1em 0;}#yiv2036139967 #yiv2036139967ygrp-text tt {font-size:120%;}#yiv2036139967 #yiv2036139967ygrp-vital ul li:last-child {border-right:none !important;}#yiv2036139967  

IMG_20200530_193346_155.jpg (156K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Balas: Re: [belajar-excel] Form Copy Paste [3 Attachments]

Syahri
In reply to this post by hendrik karnadi
Contoh file dummy

Dikirim dari Yahoo Mail di Android
 
  Pada Sab, 30 Mei 2020 pada 21:35, hendrik karnadi [hidden email] [belajar-excel]<[hidden email]> menulis:      

 Prinsipnya bisa.Coba kirim Dummy Sheets inputnya dan Output yang diinginkan.
Salam,HK

    On Saturday, 30 May 2020, 06:36:16 pm GMT+7, syahri indonesia [hidden email] [belajar-excel] <[hidden email]> wrote:  
 
    


Mohon maaf para Suhu. Apa bisa dibuatkan macro untuk menjalankan form seperti pada gambar? Terima kasih

Dikirim dari Yahoo Mail di Android      #yiv8954036753 #yiv8954036753 -- #yiv8954036753ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8954036753 #yiv8954036753ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8954036753 #yiv8954036753ygrp-mkp #yiv8954036753hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8954036753 #yiv8954036753ygrp-mkp #yiv8954036753ads {margin-bottom:10px;}#yiv8954036753 #yiv8954036753ygrp-mkp .yiv8954036753ad {padding:0 0;}#yiv8954036753 #yiv8954036753ygrp-mkp .yiv8954036753ad p {margin:0;}#yiv8954036753 #yiv8954036753ygrp-mkp .yiv8954036753ad a {color:#0000ff;text-decoration:none;}#yiv8954036753 #yiv8954036753ygrp-sponsor #yiv8954036753ygrp-lc {font-family:Arial;}#yiv8954036753 #yiv8954036753ygrp-sponsor #yiv8954036753ygrp-lc #yiv8954036753hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8954036753 #yiv8954036753ygrp-sponsor #yiv8954036753ygrp-lc .yiv8954036753ad {margin-bottom:10px;padding:0 0;}#yiv8954036753 #yiv8954036753actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8954036753 #yiv8954036753activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8954036753 #yiv8954036753activity span {font-weight:700;}#yiv8954036753 #yiv8954036753activity span:first-child {text-transform:uppercase;}#yiv8954036753 #yiv8954036753activity span a {color:#5085b6;text-decoration:none;}#yiv8954036753 #yiv8954036753activity span span {color:#ff7900;}#yiv8954036753 #yiv8954036753activity span .yiv8954036753underline {text-decoration:underline;}#yiv8954036753 .yiv8954036753attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8954036753 .yiv8954036753attach div a {text-decoration:none;}#yiv8954036753 .yiv8954036753attach img {border:none;padding-right:5px;}#yiv8954036753 .yiv8954036753attach label {display:block;margin-bottom:5px;}#yiv8954036753 .yiv8954036753attach label a {text-decoration:none;}#yiv8954036753 blockquote {margin:0 0 0 4px;}#yiv8954036753 .yiv8954036753bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8954036753 .yiv8954036753bold a {text-decoration:none;}#yiv8954036753 dd.yiv8954036753last p a {font-family:Verdana;font-weight:700;}#yiv8954036753 dd.yiv8954036753last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8954036753 dd.yiv8954036753last p span.yiv8954036753yshortcuts {margin-right:0;}#yiv8954036753 div.yiv8954036753attach-table div div a {text-decoration:none;}#yiv8954036753 div.yiv8954036753attach-table {width:400px;}#yiv8954036753 div.yiv8954036753file-title a, #yiv8954036753 div.yiv8954036753file-title a:active, #yiv8954036753 div.yiv8954036753file-title a:hover, #yiv8954036753 div.yiv8954036753file-title a:visited {text-decoration:none;}#yiv8954036753 div.yiv8954036753photo-title a, #yiv8954036753 div.yiv8954036753photo-title a:active, #yiv8954036753 div.yiv8954036753photo-title a:hover, #yiv8954036753 div.yiv8954036753photo-title a:visited {text-decoration:none;}#yiv8954036753 div#yiv8954036753ygrp-mlmsg #yiv8954036753ygrp-msg p a span.yiv8954036753yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8954036753 .yiv8954036753green {color:#628c2a;}#yiv8954036753 .yiv8954036753MsoNormal {margin:0 0 0 0;}#yiv8954036753 o {font-size:0;}#yiv8954036753 #yiv8954036753photos div {float:left;width:72px;}#yiv8954036753 #yiv8954036753photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv8954036753 #yiv8954036753photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8954036753 #yiv8954036753reco-category {font-size:77%;}#yiv8954036753 #yiv8954036753reco-desc {font-size:77%;}#yiv8954036753 .yiv8954036753replbq {margin:4px;}#yiv8954036753 #yiv8954036753ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8954036753 #yiv8954036753ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8954036753 #yiv8954036753ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8954036753 #yiv8954036753ygrp-mlmsg select, #yiv8954036753 input, #yiv8954036753 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8954036753 #yiv8954036753ygrp-mlmsg pre, #yiv8954036753 code {font:115% monospace;}#yiv8954036753 #yiv8954036753ygrp-mlmsg * {line-height:1.22em;}#yiv8954036753 #yiv8954036753ygrp-mlmsg #yiv8954036753logo {padding-bottom:10px;}#yiv8954036753 #yiv8954036753ygrp-msg p a {font-family:Verdana;}#yiv8954036753 #yiv8954036753ygrp-msg p#yiv8954036753attach-count span {color:#1E66AE;font-weight:700;}#yiv8954036753 #yiv8954036753ygrp-reco #yiv8954036753reco-head {color:#ff7900;font-weight:700;}#yiv8954036753 #yiv8954036753ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8954036753 #yiv8954036753ygrp-sponsor #yiv8954036753ov li a {font-size:130%;text-decoration:none;}#yiv8954036753 #yiv8954036753ygrp-sponsor #yiv8954036753ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8954036753 #yiv8954036753ygrp-sponsor #yiv8954036753ov ul {margin:0;padding:0 0 0 8px;}#yiv8954036753 #yiv8954036753ygrp-text {font-family:Georgia;}#yiv8954036753 #yiv8954036753ygrp-text p {margin:0 0 1em 0;}#yiv8954036753 #yiv8954036753ygrp-text tt {font-size:120%;}#yiv8954036753 #yiv8954036753ygrp-vital ul li:last-child {border-right:none !important;}#yiv8954036753  

Source File.xlsx (22K) Download Attachment
Target File.xlsx (16K) Download Attachment
IMG_20200530_193346_155.jpg (156K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Balas: Re: [belajar-excel] Form Copy Paste [3 Attachments]

Syahri
In reply to this post by hendrik karnadi

Contoh file dummy
Dikirim dari Yahoo Mail di Android
 
  Pada Sab, 30 Mei 2020 pada 21:35, hendrik karnadi [hidden email] [belajar-excel]<[hidden email]> menulis:      

 Prinsipnya bisa.Coba kirim Dummy Sheets inputnya dan Output yang diinginkan.
Salam,HK

    On Saturday, 30 May 2020, 06:36:16 pm GMT+7, syahri indonesia [hidden email] [belajar-excel] <[hidden email]> wrote:  
 
    


Mohon maaf para Suhu. Apa bisa dibuatkan macro untuk menjalankan form seperti pada gambar? Terima kasih

Dikirim dari Yahoo Mail di Android      #yiv8954036753 #yiv8954036753 -- #yiv8954036753ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8954036753 #yiv8954036753ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8954036753 #yiv8954036753ygrp-mkp #yiv8954036753hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8954036753 #yiv8954036753ygrp-mkp #yiv8954036753ads {margin-bottom:10px;}#yiv8954036753 #yiv8954036753ygrp-mkp .yiv8954036753ad {padding:0 0;}#yiv8954036753 #yiv8954036753ygrp-mkp .yiv8954036753ad p {margin:0;}#yiv8954036753 #yiv8954036753ygrp-mkp .yiv8954036753ad a {color:#0000ff;text-decoration:none;}#yiv8954036753 #yiv8954036753ygrp-sponsor #yiv8954036753ygrp-lc {font-family:Arial;}#yiv8954036753 #yiv8954036753ygrp-sponsor #yiv8954036753ygrp-lc #yiv8954036753hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8954036753 #yiv8954036753ygrp-sponsor #yiv8954036753ygrp-lc .yiv8954036753ad {margin-bottom:10px;padding:0 0;}#yiv8954036753 #yiv8954036753actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8954036753 #yiv8954036753activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8954036753 #yiv8954036753activity span {font-weight:700;}#yiv8954036753 #yiv8954036753activity span:first-child {text-transform:uppercase;}#yiv8954036753 #yiv8954036753activity span a {color:#5085b6;text-decoration:none;}#yiv8954036753 #yiv8954036753activity span span {color:#ff7900;}#yiv8954036753 #yiv8954036753activity span .yiv8954036753underline {text-decoration:underline;}#yiv8954036753 .yiv8954036753attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8954036753 .yiv8954036753attach div a {text-decoration:none;}#yiv8954036753 .yiv8954036753attach img {border:none;padding-right:5px;}#yiv8954036753 .yiv8954036753attach label {display:block;margin-bottom:5px;}#yiv8954036753 .yiv8954036753attach label a {text-decoration:none;}#yiv8954036753 blockquote {margin:0 0 0 4px;}#yiv8954036753 .yiv8954036753bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8954036753 .yiv8954036753bold a {text-decoration:none;}#yiv8954036753 dd.yiv8954036753last p a {font-family:Verdana;font-weight:700;}#yiv8954036753 dd.yiv8954036753last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8954036753 dd.yiv8954036753last p span.yiv8954036753yshortcuts {margin-right:0;}#yiv8954036753 div.yiv8954036753attach-table div div a {text-decoration:none;}#yiv8954036753 div.yiv8954036753attach-table {width:400px;}#yiv8954036753 div.yiv8954036753file-title a, #yiv8954036753 div.yiv8954036753file-title a:active, #yiv8954036753 div.yiv8954036753file-title a:hover, #yiv8954036753 div.yiv8954036753file-title a:visited {text-decoration:none;}#yiv8954036753 div.yiv8954036753photo-title a, #yiv8954036753 div.yiv8954036753photo-title a:active, #yiv8954036753 div.yiv8954036753photo-title a:hover, #yiv8954036753 div.yiv8954036753photo-title a:visited {text-decoration:none;}#yiv8954036753 div#yiv8954036753ygrp-mlmsg #yiv8954036753ygrp-msg p a span.yiv8954036753yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8954036753 .yiv8954036753green {color:#628c2a;}#yiv8954036753 .yiv8954036753MsoNormal {margin:0 0 0 0;}#yiv8954036753 o {font-size:0;}#yiv8954036753 #yiv8954036753photos div {float:left;width:72px;}#yiv8954036753 #yiv8954036753photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv8954036753 #yiv8954036753photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8954036753 #yiv8954036753reco-category {font-size:77%;}#yiv8954036753 #yiv8954036753reco-desc {font-size:77%;}#yiv8954036753 .yiv8954036753replbq {margin:4px;}#yiv8954036753 #yiv8954036753ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8954036753 #yiv8954036753ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8954036753 #yiv8954036753ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8954036753 #yiv8954036753ygrp-mlmsg select, #yiv8954036753 input, #yiv8954036753 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8954036753 #yiv8954036753ygrp-mlmsg pre, #yiv8954036753 code {font:115% monospace;}#yiv8954036753 #yiv8954036753ygrp-mlmsg * {line-height:1.22em;}#yiv8954036753 #yiv8954036753ygrp-mlmsg #yiv8954036753logo {padding-bottom:10px;}#yiv8954036753 #yiv8954036753ygrp-msg p a {font-family:Verdana;}#yiv8954036753 #yiv8954036753ygrp-msg p#yiv8954036753attach-count span {color:#1E66AE;font-weight:700;}#yiv8954036753 #yiv8954036753ygrp-reco #yiv8954036753reco-head {color:#ff7900;font-weight:700;}#yiv8954036753 #yiv8954036753ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8954036753 #yiv8954036753ygrp-sponsor #yiv8954036753ov li a {font-size:130%;text-decoration:none;}#yiv8954036753 #yiv8954036753ygrp-sponsor #yiv8954036753ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8954036753 #yiv8954036753ygrp-sponsor #yiv8954036753ov ul {margin:0;padding:0 0 0 8px;}#yiv8954036753 #yiv8954036753ygrp-text {font-family:Georgia;}#yiv8954036753 #yiv8954036753ygrp-text p {margin:0 0 1em 0;}#yiv8954036753 #yiv8954036753ygrp-text tt {font-size:120%;}#yiv8954036753 #yiv8954036753ygrp-vital ul li:last-child {border-right:none !important;}#yiv8954036753  

Source File.xlsx (22K) Download Attachment
Target File.xlsx (16K) Download Attachment
IMG_20200530_193346_155.jpg (156K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Balas: Re: [belajar-excel] Form Copy Paste [1 Attachment]

hendrik karnadi
In reply to this post by Syahri
 Maaf, ternyata filenya ga semudah gambarnya.Saya pikir digabung langsung tanpa transpose.Kayaknya perlu pakar formula.

Salam,HK

    Pada Sabtu, 30 Mei 2020 21.31.20 WIB, syahri indonesia [hidden email] [belajar-excel] <[hidden email]> menulis:  
 
    
Contoh file dummy


Dikirim dari Yahoo Mail di Android
 
  Pada Sab, 30 Mei 2020 pada 21:35, hendrik karnadi [hidden email] [belajar-excel]<[hidden email]> menulis:      

 Prinsipnya bisa.Coba kirim Dummy Sheets inputnya dan Output yang diinginkan.
Salam,HK

    On Saturday, 30 May 2020, 06:36:16 pm GMT+7, syahri indonesia [hidden email] [belajar-excel] <[hidden email]> wrote:  
 
    


Mohon maaf para Suhu. Apa bisa dibuatkan macro untuk menjalankan form seperti pada gambar? Terima kasih

Dikirim dari Yahoo Mail di Android        
   

IMG_20200530_193346_155.jpg (156K) Download Attachment