RE: [belajar-excel] Hide row, Nomor urut otomatis berubah

Wed, 15 Feb 2017 20:22:00 -0800 

Nah mas ari,

Pertanyaan berikut adalah bagaimana kriteria untuk menyembunyikannya,

Apakah klik select atau orang yg input nya musti klik button terpisah?

Monggo di ulik ya mas ari,



Salam bexcel



*From:* [email protected] [mailto:[email protected]]

*Sent:* Wednesday, February 15, 2017 5:50 AM
*To:* [email protected]
*Subject:* Bls: [belajar-excel] Hide row, Nomor urut otomatis berubah [1
Attachment]





lihat di attachment
pada tabel asal di sheet sebelum beri tanda silang (X) pada row yang ingin
disembunyikan selanutnya lihat hasilnya di sheet setelah

wassalam

Ghozi Alkatiri
--------------------------------------------
Pada Sel, 14/2/17, Aku Ary [email protected] [belajar-excel] <
[email protected]> menulis:

Judul: [belajar-excel] Hide row, Nomor urut otomatis berubah [1 Attachment]
Kepada: [email protected]
Tanggal: Selasa, 14 Februari, 2017, 2:35 PM












Dear Para Suhu,
Mohon
bimbingannya..Apabila melakukan hide pada baris tertentu, maka nomor
urut secara otomatis akan ikut berubah mengikuti sesuai
urutan yang ada (hanya tampil urutan dari data yang tidak di
hidden).
Terima kasih atas bantuan dan
pencerahannya.
Mohon maaf apabila sudah pernah
dibahas sebelumnya..

salam,ary
*terlampir contoh kasus
sederhana









#yiv3269378210 #yiv3269378210 --
#yiv3269378210ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv3269378210 #yiv3269378210ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv3269378210 #yiv3269378210ygrp-mkp #yiv3269378210hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv3269378210 #yiv3269378210ygrp-mkp #yiv3269378210ads {
margin-bottom:10px;}

#yiv3269378210 #yiv3269378210ygrp-mkp .yiv3269378210ad {
padding:0 0;}

#yiv3269378210 #yiv3269378210ygrp-mkp .yiv3269378210ad p {
margin:0;}

#yiv3269378210 #yiv3269378210ygrp-mkp .yiv3269378210ad a {
color:#0000ff;text-decoration:none;}
#yiv3269378210 #yiv3269378210ygrp-sponsor
#yiv3269378210ygrp-lc {
font-family:Arial;}

#yiv3269378210 #yiv3269378210ygrp-sponsor
#yiv3269378210ygrp-lc #yiv3269378210hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv3269378210 #yiv3269378210ygrp-sponsor
#yiv3269378210ygrp-lc .yiv3269378210ad {
margin-bottom:10px;padding:0 0;}

#yiv3269378210 #yiv3269378210actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv3269378210 #yiv3269378210activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv3269378210 #yiv3269378210activity span {
font-weight:700;}

#yiv3269378210 #yiv3269378210activity span:first-child {
text-transform:uppercase;}

#yiv3269378210 #yiv3269378210activity span a {
color:#5085b6;text-decoration:none;}

#yiv3269378210 #yiv3269378210activity span span {
color:#ff7900;}

#yiv3269378210 #yiv3269378210activity span
.yiv3269378210underline {
text-decoration:underline;}

#yiv3269378210 .yiv3269378210attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv3269378210 .yiv3269378210attach div a {
text-decoration:none;}

#yiv3269378210 .yiv3269378210attach img {
border:none;padding-right:5px;}

#yiv3269378210 .yiv3269378210attach label {
display:block;margin-bottom:5px;}

#yiv3269378210 .yiv3269378210attach label a {
text-decoration:none;}

#yiv3269378210 blockquote {
margin:0 0 0 4px;}

#yiv3269378210 .yiv3269378210bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv3269378210 .yiv3269378210bold a {
text-decoration:none;}

#yiv3269378210 dd.yiv3269378210last p a {
font-family:Verdana;font-weight:700;}

#yiv3269378210 dd.yiv3269378210last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv3269378210 dd.yiv3269378210last p
span.yiv3269378210yshortcuts {
margin-right:0;}

#yiv3269378210 div.yiv3269378210attach-table div div a {
text-decoration:none;}

#yiv3269378210 div.yiv3269378210attach-table {
width:400px;}

#yiv3269378210 div.yiv3269378210file-title a, #yiv3269378210
div.yiv3269378210file-title a:active, #yiv3269378210
div.yiv3269378210file-title a:hover, #yiv3269378210
div.yiv3269378210file-title a:visited {
text-decoration:none;}

#yiv3269378210 div.yiv3269378210photo-title a,
#yiv3269378210 div.yiv3269378210photo-title a:active,
#yiv3269378210 div.yiv3269378210photo-title a:hover,
#yiv3269378210 div.yiv3269378210photo-title a:visited {
text-decoration:none;}

#yiv3269378210 div#yiv3269378210ygrp-mlmsg
#yiv3269378210ygrp-msg p a span.yiv3269378210yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv3269378210 .yiv3269378210green {
color:#628c2a;}

#yiv3269378210 .yiv3269378210MsoNormal {
margin:0 0 0 0;}

#yiv3269378210 o {
font-size:0;}

#yiv3269378210 #yiv3269378210photos div {
float:left;width:72px;}

#yiv3269378210 #yiv3269378210photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv3269378210 #yiv3269378210photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv3269378210 #yiv3269378210reco-category {
font-size:77%;}

#yiv3269378210 #yiv3269378210reco-desc {
font-size:77%;}

#yiv3269378210 .yiv3269378210replbq {
margin:4px;}

#yiv3269378210 #yiv3269378210ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv3269378210 #yiv3269378210ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv3269378210 #yiv3269378210ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv3269378210 #yiv3269378210ygrp-mlmsg select,
#yiv3269378210 input, #yiv3269378210 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv3269378210 #yiv3269378210ygrp-mlmsg pre, #yiv3269378210
code {
font:115% monospace;}

#yiv3269378210 #yiv3269378210ygrp-mlmsg * {
line-height:1.22em;}

#yiv3269378210 #yiv3269378210ygrp-mlmsg #yiv3269378210logo {
padding-bottom:10px;}


#yiv3269378210 #yiv3269378210ygrp-msg p a {
font-family:Verdana;}

#yiv3269378210 #yiv3269378210ygrp-msg
p#yiv3269378210attach-count span {
color:#1E66AE;font-weight:700;}

#yiv3269378210 #yiv3269378210ygrp-reco
#yiv3269378210reco-head {
color:#ff7900;font-weight:700;}

#yiv3269378210 #yiv3269378210ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv3269378210 #yiv3269378210ygrp-sponsor #yiv3269378210ov
li a {
font-size:130%;text-decoration:none;}

#yiv3269378210 #yiv3269378210ygrp-sponsor #yiv3269378210ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv3269378210 #yiv3269378210ygrp-sponsor #yiv3269378210ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv3269378210 #yiv3269378210ygrp-text {
font-family:Georgia;}

#yiv3269378210 #yiv3269378210ygrp-text p {
margin:0 0 1em 0;}

#yiv3269378210 #yiv3269378210ygrp-text tt {
font-size:120%;}

#yiv3269378210 #yiv3269378210ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv3269378210

Kirim email ke