alhamdulilah bisa mas fajar untuk attach yang saya kirim..tapi begitu diterapkan ke database yang sebenranya ga mau jalan..kalo analisa saya kenapa ga bisa karena BLANK yg ga mau mungkin hasil olahan formula meskipun kalo diliat seacara mata kosong ga ada isinya bahkan saya cek dengan countblank juga emang blank...jadi selalu muncul NO CELL WERE FOUND...mugnkin mas fajar sama yang lain bisa menambahkan trik lain.. SalamSeismica
Pada Jumat, 12 Juni 2015 15:55, "Fajar Fatahillah
[email protected] [belajar-excel]" <[email protected]>
menulis:
#yiv5938525709 --
.yiv5938525709ygrp-photo-title{clear:both;font-size:smaller;height:15px;overflow:hidden;text-align:center;width:75px;}#yiv5938525709
div.yiv5938525709ygrp-photo{background-position:center;background-repeat:no-repeat;background-color:white;border:1px
solid black;height:62px;width:62px;}#yiv5938525709
div.yiv5938525709photo-title a, #yiv5938525709 div.yiv5938525709photo-title
a:active, #yiv5938525709 div.yiv5938525709photo-title a:hover, #yiv5938525709
div.yiv5938525709photo-title a:visited {text-decoration:none;}#yiv5938525709
div.yiv5938525709attach-table div.yiv5938525709attach-row
{clear:both;}#yiv5938525709 div.yiv5938525709attach-table
div.yiv5938525709attach-row div {float:left;}#yiv5938525709 p
{clear:both;padding:15px 0 3px 0;overflow:hidden;}#yiv5938525709
div.yiv5938525709ygrp-file {width:30px;}#yiv5938525709
div.yiv5938525709attach-table div.yiv5938525709attach-row div div a
{text-decoration:none;}#yiv5938525709 div.yiv5938525709attach-table
div.yiv5938525709attach-row div div span {font-weight:normal;}#yiv5938525709
div.yiv5938525709ygrp-file-title {font-weight:bold;}#yiv5938525709
Wa'alaikumsalam,dear Mba Zerlinda,menurut saya caranya,blok A4:B14Pencet tombol
F5Klik Specialklik Blank > klik Oklalu tekan ctrl+(-)Lalu pilih Shift cells
updonesemoga berhasil
Best Regards,
Fajar Fatahillah
On Friday, June 12, 2015 1:12 PM, "Zerlinda Seismica [email protected]
[belajar-excel]" <[email protected]> wrote:
Assalamualaikum wrwb
Selamat siang para expert dan sesepuh.
Ada yang ingin saya share dan minta petunjuk..adakah triknya supaya baris bawah
bisa naik keatas sehingga menjadi rapi seperti lampiran ini
Salam
Seismica
#yiv5938525709 -- #yiv5938525709ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5938525709
#yiv5938525709ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5938525709
#yiv5938525709ygrp-mkp #yiv5938525709hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv5938525709 #yiv5938525709ygrp-mkp #yiv5938525709ads
{margin-bottom:10px;}#yiv5938525709 #yiv5938525709ygrp-mkp .yiv5938525709ad
{padding:0 0;}#yiv5938525709 #yiv5938525709ygrp-mkp .yiv5938525709ad p
{margin:0;}#yiv5938525709 #yiv5938525709ygrp-mkp .yiv5938525709ad a
{color:#0000ff;text-decoration:none;}#yiv5938525709 #yiv5938525709ygrp-sponsor
#yiv5938525709ygrp-lc {font-family:Arial;}#yiv5938525709
#yiv5938525709ygrp-sponsor #yiv5938525709ygrp-lc #yiv5938525709hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5938525709
#yiv5938525709ygrp-sponsor #yiv5938525709ygrp-lc .yiv5938525709ad
{margin-bottom:10px;padding:0 0;}#yiv5938525709 #yiv5938525709actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5938525709
#yiv5938525709activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5938525709
#yiv5938525709activity span {font-weight:700;}#yiv5938525709
#yiv5938525709activity span:first-child
{text-transform:uppercase;}#yiv5938525709 #yiv5938525709activity span a
{color:#5085b6;text-decoration:none;}#yiv5938525709 #yiv5938525709activity span
span {color:#ff7900;}#yiv5938525709 #yiv5938525709activity span
.yiv5938525709underline {text-decoration:underline;}#yiv5938525709
.yiv5938525709attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv5938525709 .yiv5938525709attach div a
{text-decoration:none;}#yiv5938525709 .yiv5938525709attach img
{border:none;padding-right:5px;}#yiv5938525709 .yiv5938525709attach label
{display:block;margin-bottom:5px;}#yiv5938525709 .yiv5938525709attach label a
{text-decoration:none;}#yiv5938525709 blockquote {margin:0 0 0
4px;}#yiv5938525709 .yiv5938525709bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5938525709
.yiv5938525709bold a {text-decoration:none;}#yiv5938525709 dd.yiv5938525709last
p a {font-family:Verdana;font-weight:700;}#yiv5938525709 dd.yiv5938525709last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5938525709
dd.yiv5938525709last p span.yiv5938525709yshortcuts
{margin-right:0;}#yiv5938525709 div.yiv5938525709attach-table div div a
{text-decoration:none;}#yiv5938525709 div.yiv5938525709attach-table
{width:400px;}#yiv5938525709 div.yiv5938525709file-title a, #yiv5938525709
div.yiv5938525709file-title a:active, #yiv5938525709
div.yiv5938525709file-title a:hover, #yiv5938525709 div.yiv5938525709file-title
a:visited {text-decoration:none;}#yiv5938525709 div.yiv5938525709photo-title a,
#yiv5938525709 div.yiv5938525709photo-title a:active, #yiv5938525709
div.yiv5938525709photo-title a:hover, #yiv5938525709
div.yiv5938525709photo-title a:visited {text-decoration:none;}#yiv5938525709
div#yiv5938525709ygrp-mlmsg #yiv5938525709ygrp-msg p a
span.yiv5938525709yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5938525709
.yiv5938525709green {color:#628c2a;}#yiv5938525709 .yiv5938525709MsoNormal
{margin:0 0 0 0;}#yiv5938525709 o {font-size:0;}#yiv5938525709
#yiv5938525709photos div {float:left;width:72px;}#yiv5938525709
#yiv5938525709photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv5938525709
#yiv5938525709photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5938525709
#yiv5938525709reco-category {font-size:77%;}#yiv5938525709
#yiv5938525709reco-desc {font-size:77%;}#yiv5938525709 .yiv5938525709replbq
{margin:4px;}#yiv5938525709 #yiv5938525709ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv5938525709 #yiv5938525709ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5938525709
#yiv5938525709ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5938525709
#yiv5938525709ygrp-mlmsg select, #yiv5938525709 input, #yiv5938525709 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv5938525709
#yiv5938525709ygrp-mlmsg pre, #yiv5938525709 code {font:115%
monospace;}#yiv5938525709 #yiv5938525709ygrp-mlmsg *
{line-height:1.22em;}#yiv5938525709 #yiv5938525709ygrp-mlmsg #yiv5938525709logo
{padding-bottom:10px;}#yiv5938525709 #yiv5938525709ygrp-msg p a
{font-family:Verdana;}#yiv5938525709 #yiv5938525709ygrp-msg
p#yiv5938525709attach-count span {color:#1E66AE;font-weight:700;}#yiv5938525709
#yiv5938525709ygrp-reco #yiv5938525709reco-head
{color:#ff7900;font-weight:700;}#yiv5938525709 #yiv5938525709ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv5938525709 #yiv5938525709ygrp-sponsor
#yiv5938525709ov li a {font-size:130%;text-decoration:none;}#yiv5938525709
#yiv5938525709ygrp-sponsor #yiv5938525709ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv5938525709
#yiv5938525709ygrp-sponsor #yiv5938525709ov ul {margin:0;padding:0 0 0
8px;}#yiv5938525709 #yiv5938525709ygrp-text
{font-family:Georgia;}#yiv5938525709 #yiv5938525709ygrp-text p {margin:0 0 1em
0;}#yiv5938525709 #yiv5938525709ygrp-text tt {font-size:120%;}#yiv5938525709
#yiv5938525709ygrp-vital ul li:last-child {border-right:none
!important;}#yiv5938525709
Data yang tidak bisa pake tips mas fajar.xlsx
Description: MS-Excel 2007 spreadsheet
