Hai Farud, Coba contoh ini, ini menggunakan VBA, jadi jangan lupa activekan Macro Enabelednya.1. Pada Sheet1 membuat table sesuai dengan angka yang di masukan pada kolom E22. Pada Sheet2 membuat table dengan menuliskan Nama Pembina. Untuk Sheet2 di batasi jumlah Nama Pembinanya. Semoga bisa membantu.
TerimaKasih.
Pada Jumat, 20 Mei 2016 10:40, "farud oke [email protected]
[belajar-excel]" <[email protected]> menulis:
penulisan formula vba-nya seperti apa mas soalnya saya awam & baru
belajar masalah excel dan seluk beluknya.terimakasih sebelumnya
Pada 20 Mei 2016 08.17, Toby kenzo [email protected] [belajar-excel]
<[email protected]> menulis:
| Hai..Untuk membuat table seperti itu, anda harus menggunakan VBA dgn Event
Worksheet_Change sebagai trigger untuk membuat berapa banyak cell yg di
butuhkan untuk membuatnya, kemudian gunakan method "do while","Borders" dan
"Cells / Range" untuk mewarnai cell atau range, gunakan method "Interior.color
atau interior.colorindex"
TerimaKasih.Sent from Yahoo Mail on Android |
From: farud oke [email protected] [belajar-excel]
<[email protected]>;
To: <[email protected]>;
Subject: [belajar-excel] Membuat Baris otomatis sesuai dengan yang diisikan
[1 Attachment]
Sent: Thu, May 19, 2016 8:41:35 AM
| Assalamualaikum... Saya mendapatkan file (terlampir) dan ada 2 hal yg
ingin saya tanyakan mohon bantuannya para master excel sekalian1. Pada sheet
"honor" di sell F2,N2,T2 dan Z2 apabila diisi dengan angka maka otomatis
kebawah akan membuat tabel sesuai dengan banyaknya angka yang ditulis di sell
tadi.Pertanyaanya : Bagaimana caranya sehingga sheet seperti itu bisa dibuat?2.
Pada sheet "daftar ptk" disell B4 kebawah apabila diisi akan membuat tabel
kebawah secara otomatis juga.Pertanyaanya sama mas,bagaimana caranya membuat
sheet yang seperti itu? Mohon penjelasannya mas karena saya lagi baru belajar
jadi masih banyak yg tidak tau.Sebelumnya saya ucapkan terimakasih.. |
#yiv4279147918 #yiv4279147918 -- #yiv4279147918ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4279147918
#yiv4279147918ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4279147918
#yiv4279147918ygrp-mkp #yiv4279147918hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4279147918 #yiv4279147918ygrp-mkp #yiv4279147918ads
{margin-bottom:10px;}#yiv4279147918 #yiv4279147918ygrp-mkp .yiv4279147918ad
{padding:0 0;}#yiv4279147918 #yiv4279147918ygrp-mkp .yiv4279147918ad p
{margin:0;}#yiv4279147918 #yiv4279147918ygrp-mkp .yiv4279147918ad a
{color:#0000ff;text-decoration:none;}#yiv4279147918 #yiv4279147918ygrp-sponsor
#yiv4279147918ygrp-lc {font-family:Arial;}#yiv4279147918
#yiv4279147918ygrp-sponsor #yiv4279147918ygrp-lc #yiv4279147918hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4279147918
#yiv4279147918ygrp-sponsor #yiv4279147918ygrp-lc .yiv4279147918ad
{margin-bottom:10px;padding:0 0;}#yiv4279147918 #yiv4279147918actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4279147918
#yiv4279147918activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4279147918
#yiv4279147918activity span {font-weight:700;}#yiv4279147918
#yiv4279147918activity span:first-child
{text-transform:uppercase;}#yiv4279147918 #yiv4279147918activity span a
{color:#5085b6;text-decoration:none;}#yiv4279147918 #yiv4279147918activity span
span {color:#ff7900;}#yiv4279147918 #yiv4279147918activity span
.yiv4279147918underline {text-decoration:underline;}#yiv4279147918
.yiv4279147918attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4279147918 .yiv4279147918attach div a
{text-decoration:none;}#yiv4279147918 .yiv4279147918attach img
{border:none;padding-right:5px;}#yiv4279147918 .yiv4279147918attach label
{display:block;margin-bottom:5px;}#yiv4279147918 .yiv4279147918attach label a
{text-decoration:none;}#yiv4279147918 blockquote {margin:0 0 0
4px;}#yiv4279147918 .yiv4279147918bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4279147918
.yiv4279147918bold a {text-decoration:none;}#yiv4279147918 dd.yiv4279147918last
p a {font-family:Verdana;font-weight:700;}#yiv4279147918 dd.yiv4279147918last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4279147918
dd.yiv4279147918last p span.yiv4279147918yshortcuts
{margin-right:0;}#yiv4279147918 div.yiv4279147918attach-table div div a
{text-decoration:none;}#yiv4279147918 div.yiv4279147918attach-table
{width:400px;}#yiv4279147918 div.yiv4279147918file-title a, #yiv4279147918
div.yiv4279147918file-title a:active, #yiv4279147918
div.yiv4279147918file-title a:hover, #yiv4279147918 div.yiv4279147918file-title
a:visited {text-decoration:none;}#yiv4279147918 div.yiv4279147918photo-title a,
#yiv4279147918 div.yiv4279147918photo-title a:active, #yiv4279147918
div.yiv4279147918photo-title a:hover, #yiv4279147918
div.yiv4279147918photo-title a:visited {text-decoration:none;}#yiv4279147918
div#yiv4279147918ygrp-mlmsg #yiv4279147918ygrp-msg p a
span.yiv4279147918yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4279147918
.yiv4279147918green {color:#628c2a;}#yiv4279147918 .yiv4279147918MsoNormal
{margin:0 0 0 0;}#yiv4279147918 o {font-size:0;}#yiv4279147918
#yiv4279147918photos div {float:left;width:72px;}#yiv4279147918
#yiv4279147918photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv4279147918
#yiv4279147918photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4279147918
#yiv4279147918reco-category {font-size:77%;}#yiv4279147918
#yiv4279147918reco-desc {font-size:77%;}#yiv4279147918 .yiv4279147918replbq
{margin:4px;}#yiv4279147918 #yiv4279147918ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4279147918 #yiv4279147918ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4279147918
#yiv4279147918ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4279147918
#yiv4279147918ygrp-mlmsg select, #yiv4279147918 input, #yiv4279147918 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4279147918
#yiv4279147918ygrp-mlmsg pre, #yiv4279147918 code {font:115%
monospace;}#yiv4279147918 #yiv4279147918ygrp-mlmsg *
{line-height:1.22em;}#yiv4279147918 #yiv4279147918ygrp-mlmsg #yiv4279147918logo
{padding-bottom:10px;}#yiv4279147918 #yiv4279147918ygrp-msg p a
{font-family:Verdana;}#yiv4279147918 #yiv4279147918ygrp-msg
p#yiv4279147918attach-count span {color:#1E66AE;font-weight:700;}#yiv4279147918
#yiv4279147918ygrp-reco #yiv4279147918reco-head
{color:#ff7900;font-weight:700;}#yiv4279147918 #yiv4279147918ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4279147918 #yiv4279147918ygrp-sponsor
#yiv4279147918ov li a {font-size:130%;text-decoration:none;}#yiv4279147918
#yiv4279147918ygrp-sponsor #yiv4279147918ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4279147918
#yiv4279147918ygrp-sponsor #yiv4279147918ov ul {margin:0;padding:0 0 0
8px;}#yiv4279147918 #yiv4279147918ygrp-text
{font-family:Georgia;}#yiv4279147918 #yiv4279147918ygrp-text p {margin:0 0 1em
0;}#yiv4279147918 #yiv4279147918ygrp-text tt {font-size:120%;}#yiv4279147918
#yiv4279147918ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4279147918
buat table1.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
