Dear Ayub,
Bisa di kasi contohnya...Apa yang sudah anda buat dan apa yang ingin anda
inginkan.
TerimaKasih.
Pada Sabtu, 28 Mei 2016 8:13, "Ayub Barin ayubba...@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Dear Pa'Nang
Wa alaikumussalam Wr.Wb.Sebelumnya terima kasih atas perhatian dan jawaban Pa'
Nang, Mohon maaf sedikit bercerita Pa'Nang, saya punya tabel bisa dibilang
database pada sheet1, isinya campuran kelompok data (data nama pegawai semua
instansi), dengan di akal-akal'i saya Alhamdulillah dapat menampilkan tabel per
kelompok data (perinstansi)bergantian sesuai keinganan dengan memilih instansi
menggunakan validasi data (list) pada sheet2, setiap kelompok data yg
ditampilkan berbeda jumlahnya, klu kelompok data cuma 10 org berati tabel akan
tampil dari A6:H15 (judulkolom tabel di A5:A11 dan head line tabel ada di
A1:H4) , dan tanda tangan kepala instansi di G18, namun kalau kelompok data yg
dimunculkan ada 5 org berarti tabel dari A6:H10 dan tanda tangan akan berada di
G13, harapan dan keinginan Pa'Nang script VBA yg seperti apa yg bisa membuat
teks nama kepala instansi utk tempat tanda tangan ini bergeser sendiri
mengikuti panjang tabel, karena idealnya tempat tanda tangan ini 2baris atw
3baris setelah baris terakhir di bawah tabel, kalau saya ketik manual terlebih
dahulu di paling bawah halaman dan isi tabel hanya 5orng maka akan terlihat
terlalu jauh dengan tempat tanda tangan.
Demikian Pa'Nang mudahan ada jawabannya, dan atas jawaban saya ucapkan
terimaksih, Wasaalamu'alaikum Wr.Wb #yiv8648866189 #yiv8648866189 --
#yiv8648866189ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}#yiv8648866189 #yiv8648866189ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv8648866189 #yiv8648866189ygrp-mkp #yiv8648866189hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8648866189 #yiv8648866189ygrp-mkp #yiv8648866189ads
{margin-bottom:10px;}#yiv8648866189 #yiv8648866189ygrp-mkp .yiv8648866189ad
{padding:0 0;}#yiv8648866189 #yiv8648866189ygrp-mkp .yiv8648866189ad p
{margin:0;}#yiv8648866189 #yiv8648866189ygrp-mkp .yiv8648866189ad a
{color:#0000ff;text-decoration:none;}#yiv8648866189 #yiv8648866189ygrp-sponsor
#yiv8648866189ygrp-lc {font-family:Arial;}#yiv8648866189
#yiv8648866189ygrp-sponsor #yiv8648866189ygrp-lc #yiv8648866189hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8648866189
#yiv8648866189ygrp-sponsor #yiv8648866189ygrp-lc .yiv8648866189ad
{margin-bottom:10px;padding:0 0;}#yiv8648866189 #yiv8648866189actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8648866189
#yiv8648866189activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8648866189
#yiv8648866189activity span {font-weight:700;}#yiv8648866189
#yiv8648866189activity span:first-child
{text-transform:uppercase;}#yiv8648866189 #yiv8648866189activity span a
{color:#5085b6;text-decoration:none;}#yiv8648866189 #yiv8648866189activity span
span {color:#ff7900;}#yiv8648866189 #yiv8648866189activity span
.yiv8648866189underline {text-decoration:underline;}#yiv8648866189
.yiv8648866189attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv8648866189 .yiv8648866189attach div a
{text-decoration:none;}#yiv8648866189 .yiv8648866189attach img
{border:none;padding-right:5px;}#yiv8648866189 .yiv8648866189attach label
{display:block;margin-bottom:5px;}#yiv8648866189 .yiv8648866189attach label a
{text-decoration:none;}#yiv8648866189 blockquote {margin:0 0 0
4px;}#yiv8648866189 .yiv8648866189bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8648866189
.yiv8648866189bold a {text-decoration:none;}#yiv8648866189 dd.yiv8648866189last
p a {font-family:Verdana;font-weight:700;}#yiv8648866189 dd.yiv8648866189last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8648866189
dd.yiv8648866189last p span.yiv8648866189yshortcuts
{margin-right:0;}#yiv8648866189 div.yiv8648866189attach-table div div a
{text-decoration:none;}#yiv8648866189 div.yiv8648866189attach-table
{width:400px;}#yiv8648866189 div.yiv8648866189file-title a, #yiv8648866189
div.yiv8648866189file-title a:active, #yiv8648866189
div.yiv8648866189file-title a:hover, #yiv8648866189 div.yiv8648866189file-title
a:visited {text-decoration:none;}#yiv8648866189 div.yiv8648866189photo-title a,
#yiv8648866189 div.yiv8648866189photo-title a:active, #yiv8648866189
div.yiv8648866189photo-title a:hover, #yiv8648866189
div.yiv8648866189photo-title a:visited {text-decoration:none;}#yiv8648866189
div#yiv8648866189ygrp-mlmsg #yiv8648866189ygrp-msg p a
span.yiv8648866189yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8648866189
.yiv8648866189green {color:#628c2a;}#yiv8648866189 .yiv8648866189MsoNormal
{margin:0 0 0 0;}#yiv8648866189 o {font-size:0;}#yiv8648866189
#yiv8648866189photos div {float:left;width:72px;}#yiv8648866189
#yiv8648866189photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv8648866189
#yiv8648866189photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8648866189
#yiv8648866189reco-category {font-size:77%;}#yiv8648866189
#yiv8648866189reco-desc {font-size:77%;}#yiv8648866189 .yiv8648866189replbq
{margin:4px;}#yiv8648866189 #yiv8648866189ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv8648866189 #yiv8648866189ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8648866189
#yiv8648866189ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8648866189
#yiv8648866189ygrp-mlmsg select, #yiv8648866189 input, #yiv8648866189 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8648866189
#yiv8648866189ygrp-mlmsg pre, #yiv8648866189 code {font:115%
monospace;}#yiv8648866189 #yiv8648866189ygrp-mlmsg *
{line-height:1.22em;}#yiv8648866189 #yiv8648866189ygrp-mlmsg #yiv8648866189logo
{padding-bottom:10px;}#yiv8648866189 #yiv8648866189ygrp-msg p a
{font-family:Verdana;}#yiv8648866189 #yiv8648866189ygrp-msg
p#yiv8648866189attach-count span {color:#1E66AE;font-weight:700;}#yiv8648866189
#yiv8648866189ygrp-reco #yiv8648866189reco-head
{color:#ff7900;font-weight:700;}#yiv8648866189 #yiv8648866189ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv8648866189 #yiv8648866189ygrp-sponsor
#yiv8648866189ov li a {font-size:130%;text-decoration:none;}#yiv8648866189
#yiv8648866189ygrp-sponsor #yiv8648866189ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8648866189
#yiv8648866189ygrp-sponsor #yiv8648866189ov ul {margin:0;padding:0 0 0
8px;}#yiv8648866189 #yiv8648866189ygrp-text
{font-family:Georgia;}#yiv8648866189 #yiv8648866189ygrp-text p {margin:0 0 1em
0;}#yiv8648866189 #yiv8648866189ygrp-text tt {font-size:120%;}#yiv8648866189
#yiv8648866189ygrp-vital ul li:last-child {border-right:none
!important;}#yiv8648866189
