Rabu, 01 April 2015

[belajar-excel] Digest Number 3367

15 Messages

Digest #3367
2a
Re: GoalSeek by "Dwi Hartanto" dwight_oke
3b
Re: Copy worksheet dengan memilih sheet yang ada by "Mr. Kid" nmkid.family@ymail.com
5a
Re: Tanya Macro by "Mr. Kid" nmkid.family@ymail.com
6a
Re: Minta tolong by "ADM PPIC_LSF"
6b
Re: Minta tolong [1 Attachment] by "hendrik karnadi" hendrikkarnadi
7
Move Cells in Filtermode by prasaja_satria

Messages

Tue Mar 31, 2015 7:43 pm (PDT) . Posted by:

"teguh indrawanto" teguh.indrawanto

Dear Mr. Toby
Sorry boss baru confirm, saya sudah sempet coba formula yg kemaren, tapi masih bingung dan selalu value..
tapi setelah liat file terlampir, semua sudah OK alias joss..terima kasih banyak atas pencerahan serta bantuannya.
regards,
Teguh

On Wednesday, April 1, 2015 9:18 AM, "Toby kenzo tobykenzo@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:


  Dear Teguh, Yang waktu itu sudah bisa belum formulanya...Ini saya kasi formula seperti yang kemarin saya buat, hasilnya ga masalah kok, saya coba di office 2013. TerimaKasih

Pada Rabu, 1 April 2015 8:40, "teguh indrawanto teguh.indrawanto@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Dear Pakar Excel ,
Mohon bantuan atas permasalahan berikut.Pada penghitungan absensi karyawan, selisih jam kerja kurang dari 1 Jam atau kelebihan jam kerja > 1 jam < 2 Jam hanya akan terhitung 1 Jam Saja. (Penjelasan Soal terlampir).
Regards,
Teguh


#yiv1901087184 #yiv1901087184 -- #yiv1901087184ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1901087184 #yiv1901087184ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1901087184 #yiv1901087184ygrp-mkp #yiv1901087184hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1901087184 #yiv1901087184ygrp-mkp #yiv1901087184ads {margin-bottom:10px;}#yiv1901087184 #yiv1901087184ygrp-mkp .yiv1901087184ad {padding:0 0;}#yiv1901087184 #yiv1901087184ygrp-mkp .yiv1901087184ad p {margin:0;}#yiv1901087184 #yiv1901087184ygrp-mkp .yiv1901087184ad a {color:#0000ff;text-decoration:none;}#yiv1901087184 #yiv1901087184ygrp-sponsor #yiv1901087184ygrp-lc {font-family:Arial;}#yiv1901087184 #yiv1901087184ygrp-sponsor #yiv1901087184ygrp-lc #yiv1901087184hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1901087184 #yiv1901087184ygrp-sponsor #yiv1901087184ygrp-lc .yiv1901087184ad {margin-bottom:10px;padding:0 0;}#yiv1901087184 #yiv1901087184actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1901087184 #yiv1901087184activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1901087184 #yiv1901087184activity span {font-weight:700;}#yiv1901087184 #yiv1901087184activity span:first-child {text-transform:uppercase;}#yiv1901087184 #yiv1901087184activity span a {color:#5085b6;text-decoration:none;}#yiv1901087184 #yiv1901087184activity span span {color:#ff7900;}#yiv1901087184 #yiv1901087184activity span .yiv1901087184underline {text-decoration:underline;}#yiv1901087184 .yiv1901087184attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1901087184 .yiv1901087184attach div a {text-decoration:none;}#yiv1901087184 .yiv1901087184attach img {border:none;padding-right:5px;}#yiv1901087184 .yiv1901087184attach label {display:block;margin-bottom:5px;}#yiv1901087184 .yiv1901087184attach label a {text-decoration:none;}#yiv1901087184 blockquote {margin:0 0 0 4px;}#yiv1901087184 .yiv1901087184bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1901087184 .yiv1901087184bold a {text-decoration:none;}#yiv1901087184 dd.yiv1901087184last p a {font-family:Verdana;font-weight:700;}#yiv1901087184 dd.yiv1901087184last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1901087184 dd.yiv1901087184last p span.yiv1901087184yshortcuts {margin-right:0;}#yiv1901087184 div.yiv1901087184attach-table div div a {text-decoration:none;}#yiv1901087184 div.yiv1901087184attach-table {width:400px;}#yiv1901087184 div.yiv1901087184file-title a, #yiv1901087184 div.yiv1901087184file-title a:active, #yiv1901087184 div.yiv1901087184file-title a:hover, #yiv1901087184 div.yiv1901087184file-title a:visited {text-decoration:none;}#yiv1901087184 div.yiv1901087184photo-title a, #yiv1901087184 div.yiv1901087184photo-title a:active, #yiv1901087184 div.yiv1901087184photo-title a:hover, #yiv1901087184 div.yiv1901087184photo-title a:visited {text-decoration:none;}#yiv1901087184 div#yiv1901087184ygrp-mlmsg #yiv1901087184ygrp-msg p a span.yiv1901087184yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1901087184 .yiv1901087184green {color:#628c2a;}#yiv1901087184 .yiv1901087184MsoNormal {margin:0 0 0 0;}#yiv1901087184 o {font-size:0;}#yiv1901087184 #yiv1901087184photos div {float:left;width:72px;}#yiv1901087184 #yiv1901087184photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv1901087184 #yiv1901087184photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1901087184 #yiv1901087184reco-category {font-size:77%;}#yiv1901087184 #yiv1901087184reco-desc {font-size:77%;}#yiv1901087184 .yiv1901087184replbq {margin:4px;}#yiv1901087184 #yiv1901087184ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1901087184 #yiv1901087184ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1901087184 #yiv1901087184ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1901087184 #yiv1901087184ygrp-mlmsg select, #yiv1901087184 input, #yiv1901087184 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1901087184 #yiv1901087184ygrp-mlmsg pre, #yiv1901087184 code {font:115% monospace;}#yiv1901087184 #yiv1901087184ygrp-mlmsg * {line-height:1.22em;}#yiv1901087184 #yiv1901087184ygrp-mlmsg #yiv1901087184logo {padding-bottom:10px;}#yiv1901087184 #yiv1901087184ygrp-msg p a {font-family:Verdana;}#yiv1901087184 #yiv1901087184ygrp-msg p#yiv1901087184attach-count span {color:#1E66AE;font-weight:700;}#yiv1901087184 #yiv1901087184ygrp-reco #yiv1901087184reco-head {color:#ff7900;font-weight:700;}#yiv1901087184 #yiv1901087184ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1901087184 #yiv1901087184ygrp-sponsor #yiv1901087184ov li a {font-size:130%;text-decoration:none;}#yiv1901087184 #yiv1901087184ygrp-sponsor #yiv1901087184ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1901087184 #yiv1901087184ygrp-sponsor #yiv1901087184ov ul {margin:0;padding:0 0 0 8px;}#yiv1901087184 #yiv1901087184ygrp-text {font-family:Georgia;}#yiv1901087184 #yiv1901087184ygrp-text p {margin:0 0 1em 0;}#yiv1901087184 #yiv1901087184ygrp-text tt {font-size:120%;}#yiv1901087184 #yiv1901087184ygrp-vital ul li:last-child {border-right:none !important;}#yiv1901087184

Tue Mar 31, 2015 9:07 pm (PDT) . Posted by:

"Dwi Hartanto" dwight_oke

Akan saya coba,, terima kasih banyakWa alaikum salam..


On Wednesday, 1 April 2015, 4:40, "'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:


  wa'alaikumussalam wr wb  (mbok yao dipanjangin dikit supaya lebih baik)

Goal seek punya 3 elemen pokok, yaitu :
> nilai_target (konstanta bertipe numerik)
> range_changing_cell
> range_set_cell (berisi formula yang link ke range changing cell)

Dengan VBA
Syntax :
    range_set_cell.goalseek nilai_target , range_changing_cell
atau jika hasil dari code di atas kurang sesuai atau tidak memuaskan karena tidak sama dengan hasil dialog window goal seek dari dalam worksheet, bisa menggunakan :
   application.executeexcel4macro _
            "GOAL.SEEK(""" _
            & alamatR1C1_range_set_cell _
            & """," _
            & nilai_target _
            & ",""" _
            & alamatR1C1_range_changing_cell _
            & """)"

A. Nilai target konstan
- nilai_target adalah konstan 5000
- range_changing_cell ada di B1:B10
- tange_set_cell (berformula) ada di A1:A10

dim lRowKe as long
for lrowke=1 to 10   'jumlah baris data dari a1:a10
      range("a1:a10").cells(lrowke).goalseek  5000 , range("b1:b10").cells(lrowke)
next lrowke

atau

dim lRowKe as long
for lrowke=1 to 10   'jumlah baris data dari a1:a10
      application.executeexcel4macro _
             "GOAL.SEEK(""" _
             & range("a1:a10").cells(lrowke).address(referencestyle:=xlR1C1) _
             & """," _
             & 5000 _
             & ",""" _
             & range("b1:b10").cells(lrowke).address(referencestyle:=xlR1C1) _
             & """)"
next lrowke

B. Nilai target setiap baris data berbeda-beda
- nilai_target ada di range C1:C10
- range_changing_cell ada di B1:B10
- tange_set_cell (berformula) ada di A1:A10

dim lRowKe as long
for lrowke=1 to 10   'jumlah baris data dari a1:a10
      range("a1:a10").cells(lrowke).goalseek  range("c1:c10").cells(lrowke).value, range("b1:b10").cells(lrowke)
next lrowke

atau

dim lRowKe as long
for lrowke=1 to 10   'jumlah baris data dari a1:a10
      application.executeexcel4macro _
             "GOAL.SEEK(""" _
             & range("a1:a10").cells(lrowke).address(referencestyle:=xlR1C1) _
             & """," _
             & range("c1:c10").cells(lrowke).value _
             & ",""" _
             & range("b1:b10").cells(lrowke).address(referencestyle:=xlR1C1) _
             & """)"
next lrowke

Selamat mencoba

wassalamu'alaikum wr wb
Kid

2015-03-30 19:20 GMT+11:00 Dwi Hartanto dwight_oke@yahoo.com.au [belajar-excel] <belajar-excel@yahoogroups.com>:

  Ass...Mau tanya dong rumus macro utk goalseek sampai data terakhirTrims
Wass..


#yiv0601517080 #yiv0601517080 -- #yiv0601517080ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0601517080 #yiv0601517080ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0601517080 #yiv0601517080ygrp-mkp #yiv0601517080hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0601517080 #yiv0601517080ygrp-mkp #yiv0601517080ads {margin-bottom:10px;}#yiv0601517080 #yiv0601517080ygrp-mkp .yiv0601517080ad {padding:0 0;}#yiv0601517080 #yiv0601517080ygrp-mkp .yiv0601517080ad p {margin:0;}#yiv0601517080 #yiv0601517080ygrp-mkp .yiv0601517080ad a {color:#0000ff;text-decoration:none;}#yiv0601517080 #yiv0601517080ygrp-sponsor #yiv0601517080ygrp-lc {font-family:Arial;}#yiv0601517080 #yiv0601517080ygrp-sponsor #yiv0601517080ygrp-lc #yiv0601517080hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0601517080 #yiv0601517080ygrp-sponsor #yiv0601517080ygrp-lc .yiv0601517080ad {margin-bottom:10px;padding:0 0;}#yiv0601517080 #yiv0601517080actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0601517080 #yiv0601517080activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0601517080 #yiv0601517080activity span {font-weight:700;}#yiv0601517080 #yiv0601517080activity span:first-child {text-transform:uppercase;}#yiv0601517080 #yiv0601517080activity span a {color:#5085b6;text-decoration:none;}#yiv0601517080 #yiv0601517080activity span span {color:#ff7900;}#yiv0601517080 #yiv0601517080activity span .yiv0601517080underline {text-decoration:underline;}#yiv0601517080 .yiv0601517080attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0601517080 .yiv0601517080attach div a {text-decoration:none;}#yiv0601517080 .yiv0601517080attach img {border:none;padding-right:5px;}#yiv0601517080 .yiv0601517080attach label {display:block;margin-bottom:5px;}#yiv0601517080 .yiv0601517080attach label a {text-decoration:none;}#yiv0601517080 blockquote {margin:0 0 0 4px;}#yiv0601517080 .yiv0601517080bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0601517080 .yiv0601517080bold a {text-decoration:none;}#yiv0601517080 dd.yiv0601517080last p a {font-family:Verdana;font-weight:700;}#yiv0601517080 dd.yiv0601517080last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0601517080 dd.yiv0601517080last p span.yiv0601517080yshortcuts {margin-right:0;}#yiv0601517080 div.yiv0601517080attach-table div div a {text-decoration:none;}#yiv0601517080 div.yiv0601517080attach-table {width:400px;}#yiv0601517080 div.yiv0601517080file-title a, #yiv0601517080 div.yiv0601517080file-title a:active, #yiv0601517080 div.yiv0601517080file-title a:hover, #yiv0601517080 div.yiv0601517080file-title a:visited {text-decoration:none;}#yiv0601517080 div.yiv0601517080photo-title a, #yiv0601517080 div.yiv0601517080photo-title a:active, #yiv0601517080 div.yiv0601517080photo-title a:hover, #yiv0601517080 div.yiv0601517080photo-title a:visited {text-decoration:none;}#yiv0601517080 div#yiv0601517080ygrp-mlmsg #yiv0601517080ygrp-msg p a span.yiv0601517080yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0601517080 .yiv0601517080green {color:#628c2a;}#yiv0601517080 .yiv0601517080MsoNormal {margin:0 0 0 0;}#yiv0601517080 o {font-size:0;}#yiv0601517080 #yiv0601517080photos div {float:left;width:72px;}#yiv0601517080 #yiv0601517080photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv0601517080 #yiv0601517080photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0601517080 #yiv0601517080reco-category {font-size:77%;}#yiv0601517080 #yiv0601517080reco-desc {font-size:77%;}#yiv0601517080 .yiv0601517080replbq {margin:4px;}#yiv0601517080 #yiv0601517080ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0601517080 #yiv0601517080ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0601517080 #yiv0601517080ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0601517080 #yiv0601517080ygrp-mlmsg select, #yiv0601517080 input, #yiv0601517080 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0601517080 #yiv0601517080ygrp-mlmsg pre, #yiv0601517080 code {font:115% monospace;}#yiv0601517080 #yiv0601517080ygrp-mlmsg * {line-height:1.22em;}#yiv0601517080 #yiv0601517080ygrp-mlmsg #yiv0601517080logo {padding-bottom:10px;}#yiv0601517080 #yiv0601517080ygrp-msg p a {font-family:Verdana;}#yiv0601517080 #yiv0601517080ygrp-msg p#yiv0601517080attach-count span {color:#1E66AE;font-weight:700;}#yiv0601517080 #yiv0601517080ygrp-reco #yiv0601517080reco-head {color:#ff7900;font-weight:700;}#yiv0601517080 #yiv0601517080ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0601517080 #yiv0601517080ygrp-sponsor #yiv0601517080ov li a {font-size:130%;text-decoration:none;}#yiv0601517080 #yiv0601517080ygrp-sponsor #yiv0601517080ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0601517080 #yiv0601517080ygrp-sponsor #yiv0601517080ov ul {margin:0;padding:0 0 0 8px;}#yiv0601517080 #yiv0601517080ygrp-text {font-family:Georgia;}#yiv0601517080 #yiv0601517080ygrp-text p {margin:0 0 1em 0;}#yiv0601517080 #yiv0601517080ygrp-text tt {font-size:120%;}#yiv0601517080 #yiv0601517080ygrp-vital ul li:last-child {border-right:none !important;}#yiv0601517080

Tue Mar 31, 2015 9:08 pm (PDT) . Posted by:

danny_06791

Untuk combobox = combobox1
Textbox = txtnama

Tue Mar 31, 2015 11:50 pm (PDT) . Posted by:

"Mr. Kid" nmkid.family@ymail.com

Coba langkah berikut :
1. buat *event initialize milik userform*
2. isi *dalam event init userform tersebut *script pengisi item berupa
nama-nama sheet dalam workbook ke combobox bernama combobox1
dim sht as worksheet
*combobox1*.clear 'buang isi combobox bernama cboSht
for each sht in thisworkbook.worksheets 'disetiap worksheet dalam
workbook
*combobox1*.additem sht.name 'tambah item berbunyi namanya
sheet yang sedang diproses ke *combobox1*
next sht 'ke sheet berikutnya kalau masih ada

3. buat *event click milik sebuah tombol* (command button) untuk copy sheet
4. *masukkan kedalam event click milik tombol tersebut* suatu proses untuk
copy sheet dan ubah nama sheet hasil copy :
'nama sheet hasil copy diambil dari* textbox bernama txtnama*
with thisworkbook.sheets
.item( combobox1.text ).copy after:= .item( .count
) 'copy sheet
.item( .count ).name =*txtnama*.text
end with

Wassalam,
Kid

On Wed, Apr 1, 2015 at 3:02 PM, danny_06791@yahoo.com [belajar-excel] <
belajar-excel@yahoogroups.com> wrote:

>
>
> Untuk combobox = combobox1
> Textbox = txtnama
>
>

Tue Mar 31, 2015 11:17 pm (PDT) . Posted by:

"Liem Suliem" liemsuliem

dhsalam be excel..saya punya data tarikan dari program yang datanya tidak rapat..maksud saya akan saya butkan kolom bantu agar data tersebut terisi di setiap baris untuk jelasnya file terlampir...
salamliem

Tue Mar 31, 2015 11:43 pm (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai Liem,Coba2 begini....Sorot sel B2 s/d B35Tekan F5, pilih special, blankKmd pada formula bar ketik =B2Lalu tekan Ctrl dan Enter bersamaan...
Salam,HK
From: "Liem Suliem liemsuliem@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Wednesday, 1 April 2015, 12:29
Subject: [belajar-excel] merapatkan data / mengisi baris yang masih kosong [1 Attachment]

  dhsalam be excel..saya punya data tarikan dari program yang datanya tidak rapat..maksud saya akan saya butkan kolom bantu agar data tersebut terisi di setiap baris untuk jelasnya file terlampir...
salamliem
#yiv9518535571 #yiv9518535571 -- #yiv9518535571ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9518535571 #yiv9518535571ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9518535571 #yiv9518535571ygrp-mkp #yiv9518535571hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9518535571 #yiv9518535571ygrp-mkp #yiv9518535571ads {margin-bottom:10px;}#yiv9518535571 #yiv9518535571ygrp-mkp .yiv9518535571ad {padding:0 0;}#yiv9518535571 #yiv9518535571ygrp-mkp .yiv9518535571ad p {margin:0;}#yiv9518535571 #yiv9518535571ygrp-mkp .yiv9518535571ad a {color:#0000ff;text-decoration:none;}#yiv9518535571 #yiv9518535571ygrp-sponsor #yiv9518535571ygrp-lc {font-family:Arial;}#yiv9518535571 #yiv9518535571ygrp-sponsor #yiv9518535571ygrp-lc #yiv9518535571hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9518535571 #yiv9518535571ygrp-sponsor #yiv9518535571ygrp-lc .yiv9518535571ad {margin-bottom:10px;padding:0 0;}#yiv9518535571 #yiv9518535571actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9518535571 #yiv9518535571activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9518535571 #yiv9518535571activity span {font-weight:700;}#yiv9518535571 #yiv9518535571activity span:first-child {text-transform:uppercase;}#yiv9518535571 #yiv9518535571activity span a {color:#5085b6;text-decoration:none;}#yiv9518535571 #yiv9518535571activity span span {color:#ff7900;}#yiv9518535571 #yiv9518535571activity span .yiv9518535571underline {text-decoration:underline;}#yiv9518535571 .yiv9518535571attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9518535571 .yiv9518535571attach div a {text-decoration:none;}#yiv9518535571 .yiv9518535571attach img {border:none;padding-right:5px;}#yiv9518535571 .yiv9518535571attach label {display:block;margin-bottom:5px;}#yiv9518535571 .yiv9518535571attach label a {text-decoration:none;}#yiv9518535571 blockquote {margin:0 0 0 4px;}#yiv9518535571 .yiv9518535571bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9518535571 .yiv9518535571bold a {text-decoration:none;}#yiv9518535571 dd.yiv9518535571last p a {font-family:Verdana;font-weight:700;}#yiv9518535571 dd.yiv9518535571last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9518535571 dd.yiv9518535571last p span.yiv9518535571yshortcuts {margin-right:0;}#yiv9518535571 div.yiv9518535571attach-table div div a {text-decoration:none;}#yiv9518535571 div.yiv9518535571attach-table {width:400px;}#yiv9518535571 div.yiv9518535571file-title a, #yiv9518535571 div.yiv9518535571file-title a:active, #yiv9518535571 div.yiv9518535571file-title a:hover, #yiv9518535571 div.yiv9518535571file-title a:visited {text-decoration:none;}#yiv9518535571 div.yiv9518535571photo-title a, #yiv9518535571 div.yiv9518535571photo-title a:active, #yiv9518535571 div.yiv9518535571photo-title a:hover, #yiv9518535571 div.yiv9518535571photo-title a:visited {text-decoration:none;}#yiv9518535571 div#yiv9518535571ygrp-mlmsg #yiv9518535571ygrp-msg p a span.yiv9518535571yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9518535571 .yiv9518535571green {color:#628c2a;}#yiv9518535571 .yiv9518535571MsoNormal {margin:0 0 0 0;}#yiv9518535571 o {font-size:0;}#yiv9518535571 #yiv9518535571photos div {float:left;width:72px;}#yiv9518535571 #yiv9518535571photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv9518535571 #yiv9518535571photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9518535571 #yiv9518535571reco-category {font-size:77%;}#yiv9518535571 #yiv9518535571reco-desc {font-size:77%;}#yiv9518535571 .yiv9518535571replbq {margin:4px;}#yiv9518535571 #yiv9518535571ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9518535571 #yiv9518535571ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9518535571 #yiv9518535571ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9518535571 #yiv9518535571ygrp-mlmsg select, #yiv9518535571 input, #yiv9518535571 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9518535571 #yiv9518535571ygrp-mlmsg pre, #yiv9518535571 code {font:115% monospace;}#yiv9518535571 #yiv9518535571ygrp-mlmsg * {line-height:1.22em;}#yiv9518535571 #yiv9518535571ygrp-mlmsg #yiv9518535571logo {padding-bottom:10px;}#yiv9518535571 #yiv9518535571ygrp-msg p a {font-family:Verdana;}#yiv9518535571 #yiv9518535571ygrp-msg p#yiv9518535571attach-count span {color:#1E66AE;font-weight:700;}#yiv9518535571 #yiv9518535571ygrp-reco #yiv9518535571reco-head {color:#ff7900;font-weight:700;}#yiv9518535571 #yiv9518535571ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9518535571 #yiv9518535571ygrp-sponsor #yiv9518535571ov li a {font-size:130%;text-decoration:none;}#yiv9518535571 #yiv9518535571ygrp-sponsor #yiv9518535571ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9518535571 #yiv9518535571ygrp-sponsor #yiv9518535571ov ul {margin:0;padding:0 0 0 8px;}#yiv9518535571 #yiv9518535571ygrp-text {font-family:Georgia;}#yiv9518535571 #yiv9518535571ygrp-text p {margin:0 0 1em 0;}#yiv9518535571 #yiv9518535571ygrp-text tt {font-size:120%;}#yiv9518535571 #yiv9518535571ygrp-vital ul li:last-child {border-right:none !important;}#yiv9518535571

Tue Mar 31, 2015 11:47 pm (PDT) . Posted by:

"Dede"

Adal gai cara yang lain Mr Liem,

Letakkan formula ini di cell c2

=IF(LEN(B2)>1;B2;C1)

Salam

DD

From: hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel] [mailto:belajar-excel@yahoogroups.com]
Sent: 01 April 2015 13:44
To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel] merapatkan data / mengisi baris yang masih kosong

Hai Liem,

Coba2 begini....

Sorot sel B2 s/d B35

Tekan F5, pilih special, blank

Kmd pada formula bar ketik =B2

Lalu tekan Ctrl dan Enter bersamaan...

Salam,

HK

_____

From: "Liem Suliem liemsuliem@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Wednesday, 1 April 2015, 12:29
Subject: [belajar-excel] merapatkan data / mengisi baris yang masih kosong [1 Attachment]

dh

salam be excel..

saya punya data tarikan dari program yang datanya tidak rapat..

maksud saya akan saya butkan kolom bantu agar data tersebut terisi di setiap baris untuk jelasnya file terlampir...

salam

liem

_____

This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual to whom it is addressed. If you have received this email in error please send it back to the person that sent it to you. Any views or opinions presented are solely those of its author and do not necessarily represent those of NABATI or any of its subsidiary companies. Unauthorized publication, use, dissemination, forwarding, printing or copying of this email and its associated attachments is strictly prohibited.

Wed Apr 1, 2015 12:34 am (PDT) . Posted by:

"uharyanto" uharyanto@ymail.com

Coba dengan code ini, (saya lupa siapa pemilik code ini, cuma ini sering
saya pake )

Sub Sel_kosong_sm_dg_atasnya()
Dim Cell As Range
For Each Cell In Selection
If Cell = "" Then
Cell.FormulaR1C1 = "=R[-1]C"
End If
Next
End Sub

cara pake :
Blok B2:B35 kemudian jalankan code nya dengan cara tekan ALT + F8

Terima kasih.

On 01/04/2015 12:29 PM, Liem Suliem liemsuliem@yahoo.co.id
[belajar-excel] wrote:
> dh
> salam be excel..
> saya punya data tarikan dari program yang datanya tidak rapat..
> maksud saya akan saya butkan kolom bantu agar data tersebut terisi di
> setiap baris untuk jelasnya file terlampir...
>
> salam
> liem
>

Wed Apr 1, 2015 12:40 am (PDT) . Posted by:

"Liem Suliem" liemsuliem

pak hk.. belum terisi semua pak...pak dede makasih pak berhasil..

Pada Rabu, 1 April 2015 13:47, "Dede pmaho_log4@nabatisnack.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


 

Adalgai cara yang lain Mr Liem,   Letakkanformula ini di cell c2 =IF(LEN(B2)>1;B2;C1)   Salam DD   From: hendrik karnadihendrikkarnadi@yahoo.com [belajar-excel] [mailto:belajar-excel@yahoogroups.com]
Sent: 01 April 2015 13:44
To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel] merapatkan data / mengisi baris yang masihkosong     Hai Liem, Coba2 begini.... Sorot sel B2 s/d B35 Tekan F5, pilih special, blank Kmd pada formula bar ketik =B2 Lalu tekan Ctrl dan Enter bersamaan...   Salam, HK   From:"Liem Suliem liemsuliem@yahoo.co.id [belajar-excel]"<belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Wednesday, 1 April 2015, 12:29
Subject: [belajar-excel] merapatkandata / mengisi baris yang masih kosong [1 Attachment]     dh salam be excel.. saya punya data tarikan dari program yang datanya tidak rapat.. maksud saya akan saya butkan kolom bantu agar data tersebut terisidi setiap baris untuk jelasnya file terlampir...   salam liem     This e-mail and any files transmitted with it are confidential andintended solely for the use of the individual to whom it is addressed. If youhave received this email in error please send it back to the person that sentit to you. Any views or opinions presented are solely those of its author anddo not necessarily represent those of NABATI or any of its subsidiarycompanies. Unauthorized publication, use, dissemination, forwarding, printingor copying of this email and its associated attachments is strictly prohibited. #yiv3310391543 -- #yiv3310391543ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3310391543 #yiv3310391543ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3310391543 #yiv3310391543ygrp-mkp #yiv3310391543hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3310391543 #yiv3310391543ygrp-mkp #yiv3310391543ads {margin-bottom:10px;}#yiv3310391543 #yiv3310391543ygrp-mkp .yiv3310391543ad {padding:0 0;}#yiv3310391543 #yiv3310391543ygrp-mkp .yiv3310391543ad p {margin:0;}#yiv3310391543 #yiv3310391543ygrp-mkp .yiv3310391543ad a {color:#0000ff;text-decoration:none;}#yiv3310391543 #yiv3310391543ygrp-sponsor #yiv3310391543ygrp-lc {font-family:Arial;}#yiv3310391543 #yiv3310391543ygrp-sponsor #yiv3310391543ygrp-lc #yiv3310391543hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3310391543 #yiv3310391543ygrp-sponsor #yiv3310391543ygrp-lc .yiv3310391543ad {margin-bottom:10px;padding:0 0;}#yiv3310391543 #yiv3310391543actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3310391543 #yiv3310391543activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3310391543 #yiv3310391543activity span {font-weight:700;}#yiv3310391543 #yiv3310391543activity span:first-child {text-transform:uppercase;}#yiv3310391543 #yiv3310391543activity span a {color:#5085b6;text-decoration:none;}#yiv3310391543 #yiv3310391543activity span span {color:#ff7900;}#yiv3310391543 #yiv3310391543activity span .yiv3310391543underline {text-decoration:underline;}#yiv3310391543 .yiv3310391543attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3310391543 .yiv3310391543attach div a {text-decoration:none;}#yiv3310391543 .yiv3310391543attach img {border:none;padding-right:5px;}#yiv3310391543 .yiv3310391543attach label {display:block;margin-bottom:5px;}#yiv3310391543 .yiv3310391543attach label a {text-decoration:none;}#yiv3310391543 blockquote {margin:0 0 0 4px;}#yiv3310391543 .yiv3310391543bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3310391543 .yiv3310391543bold a {text-decoration:none;}#yiv3310391543 dd.yiv3310391543last p a {font-family:Verdana;font-weight:700;}#yiv3310391543 dd.yiv3310391543last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3310391543 dd.yiv3310391543last p span.yiv3310391543yshortcuts {margin-right:0;}#yiv3310391543 div.yiv3310391543attach-table div div a {text-decoration:none;}#yiv3310391543 div.yiv3310391543attach-table {width:400px;}#yiv3310391543 div.yiv3310391543file-title a, #yiv3310391543 div.yiv3310391543file-title a:active, #yiv3310391543 div.yiv3310391543file-title a:hover, #yiv3310391543 div.yiv3310391543file-title a:visited {text-decoration:none;}#yiv3310391543 div.yiv3310391543photo-title a, #yiv3310391543 div.yiv3310391543photo-title a:active, #yiv3310391543 div.yiv3310391543photo-title a:hover, #yiv3310391543 div.yiv3310391543photo-title a:visited {text-decoration:none;}#yiv3310391543 div#yiv3310391543ygrp-mlmsg #yiv3310391543ygrp-msg p a span.yiv3310391543yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3310391543 .yiv3310391543green {color:#628c2a;}#yiv3310391543 .yiv3310391543MsoNormal {margin:0 0 0 0;}#yiv3310391543 o {font-size:0;}#yiv3310391543 #yiv3310391543photos div {float:left;width:72px;}#yiv3310391543 #yiv3310391543photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3310391543 #yiv3310391543photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3310391543 #yiv3310391543reco-category {font-size:77%;}#yiv3310391543 #yiv3310391543reco-desc {font-size:77%;}#yiv3310391543 .yiv3310391543replbq {margin:4px;}#yiv3310391543 #yiv3310391543ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3310391543 #yiv3310391543ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3310391543 #yiv3310391543ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3310391543 #yiv3310391543ygrp-mlmsg select, #yiv3310391543 input, #yiv3310391543 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3310391543 #yiv3310391543ygrp-mlmsg pre, #yiv3310391543 code {font:115% monospace;}#yiv3310391543 #yiv3310391543ygrp-mlmsg * {line-height:1.22em;}#yiv3310391543 #yiv3310391543ygrp-mlmsg #yiv3310391543logo {padding-bottom:10px;}#yiv3310391543 #yiv3310391543ygrp-msg p a {font-family:Verdana;}#yiv3310391543 #yiv3310391543ygrp-msg p#yiv3310391543attach-count span {color:#1E66AE;font-weight:700;}#yiv3310391543 #yiv3310391543ygrp-reco #yiv3310391543reco-head {color:#ff7900;font-weight:700;}#yiv3310391543 #yiv3310391543ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3310391543 #yiv3310391543ygrp-sponsor #yiv3310391543ov li a {font-size:130%;text-decoration:none;}#yiv3310391543 #yiv3310391543ygrp-sponsor #yiv3310391543ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3310391543 #yiv3310391543ygrp-sponsor #yiv3310391543ov ul {margin:0;padding:0 0 0 8px;}#yiv3310391543 #yiv3310391543ygrp-text {font-family:Georgia;}#yiv3310391543 #yiv3310391543ygrp-text p {margin:0 0 1em 0;}#yiv3310391543 #yiv3310391543ygrp-text tt {font-size:120%;}#yiv3310391543 #yiv3310391543ygrp-vital ul li:last-child {border-right:none !important;}#yiv3310391543

Wed Apr 1, 2015 12:43 am (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Sdh tekan Ctrl Enter pak ?
Salam,HK
From: "Liem Suliem liemsuliem@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Wednesday, 1 April 2015, 14:20
Subject: Bls: [belajar-excel] merapatkan data / mengisi baris yang masih kosong

  pak hk.. belum terisi semua pak...pak dede makasih pak berhasil..

Pada Rabu, 1 April 2015 13:47, "Dede pmaho_log4@nabatisnack.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


 

Adalgai cara yang lain Mr Liem,   Letakkanformula ini di cell c2 =IF(LEN(B2)>1;B2;C1)   Salam DD   From: hendrik karnadihendrikkarnadi@yahoo.com [belajar-excel] [mailto:belajar-excel@yahoogroups.com]
Sent: 01 April 2015 13:44
To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel] merapatkan data / mengisi baris yang masihkosong     Hai Liem, Coba2 begini.... Sorot sel B2 s/d B35 Tekan F5, pilih special, blank Kmd pada formula bar ketik =B2 Lalu tekan Ctrl dan Enter bersamaan...   Salam, HK   From:"Liem Suliem liemsuliem@yahoo.co.id [belajar-excel]"<belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Wednesday, 1 April 2015, 12:29
Subject: [belajar-excel] merapatkandata / mengisi baris yang masih kosong [1 Attachment]     dh salam be excel.. saya punya data tarikan dari program yang datanya tidak rapat.. maksud saya akan saya butkan kolom bantu agar data tersebut terisidi setiap baris untuk jelasnya file terlampir...   salam liem     This e-mail and any files transmitted with it are confidential andintended solely for the use of the individual to whom it is addressed. If youhave received this email in error please send it back to the person that sentit to you. Any views or opinions presented are solely those of its author anddo not necessarily represent those of NABATI or any of its subsidiarycompanies. Unauthorized publication, use, dissemination, forwarding, printingor copying of this email and its associated attachments is strictly prohibited.

#yiv0498113881 #yiv0498113881 -- #yiv0498113881ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0498113881 #yiv0498113881ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0498113881 #yiv0498113881ygrp-mkp #yiv0498113881hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0498113881 #yiv0498113881ygrp-mkp #yiv0498113881ads {margin-bottom:10px;}#yiv0498113881 #yiv0498113881ygrp-mkp .yiv0498113881ad {padding:0 0;}#yiv0498113881 #yiv0498113881ygrp-mkp .yiv0498113881ad p {margin:0;}#yiv0498113881 #yiv0498113881ygrp-mkp .yiv0498113881ad a {color:#0000ff;text-decoration:none;}#yiv0498113881 #yiv0498113881ygrp-sponsor #yiv0498113881ygrp-lc {font-family:Arial;}#yiv0498113881 #yiv0498113881ygrp-sponsor #yiv0498113881ygrp-lc #yiv0498113881hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0498113881 #yiv0498113881ygrp-sponsor #yiv0498113881ygrp-lc .yiv0498113881ad {margin-bottom:10px;padding:0 0;}#yiv0498113881 #yiv0498113881actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0498113881 #yiv0498113881activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0498113881 #yiv0498113881activity span {font-weight:700;}#yiv0498113881 #yiv0498113881activity span:first-child {text-transform:uppercase;}#yiv0498113881 #yiv0498113881activity span a {color:#5085b6;text-decoration:none;}#yiv0498113881 #yiv0498113881activity span span {color:#ff7900;}#yiv0498113881 #yiv0498113881activity span .yiv0498113881underline {text-decoration:underline;}#yiv0498113881 .yiv0498113881attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0498113881 .yiv0498113881attach div a {text-decoration:none;}#yiv0498113881 .yiv0498113881attach img {border:none;padding-right:5px;}#yiv0498113881 .yiv0498113881attach label {display:block;margin-bottom:5px;}#yiv0498113881 .yiv0498113881attach label a {text-decoration:none;}#yiv0498113881 blockquote {margin:0 0 0 4px;}#yiv0498113881 .yiv0498113881bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0498113881 .yiv0498113881bold a {text-decoration:none;}#yiv0498113881 dd.yiv0498113881last p a {font-family:Verdana;font-weight:700;}#yiv0498113881 dd.yiv0498113881last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0498113881 dd.yiv0498113881last p span.yiv0498113881yshortcuts {margin-right:0;}#yiv0498113881 div.yiv0498113881attach-table div div a {text-decoration:none;}#yiv0498113881 div.yiv0498113881attach-table {width:400px;}#yiv0498113881 div.yiv0498113881file-title a, #yiv0498113881 div.yiv0498113881file-title a:active, #yiv0498113881 div.yiv0498113881file-title a:hover, #yiv0498113881 div.yiv0498113881file-title a:visited {text-decoration:none;}#yiv0498113881 div.yiv0498113881photo-title a, #yiv0498113881 div.yiv0498113881photo-title a:active, #yiv0498113881 div.yiv0498113881photo-title a:hover, #yiv0498113881 div.yiv0498113881photo-title a:visited {text-decoration:none;}#yiv0498113881 div#yiv0498113881ygrp-mlmsg #yiv0498113881ygrp-msg p a span.yiv0498113881yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0498113881 .yiv0498113881green {color:#628c2a;}#yiv0498113881 .yiv0498113881MsoNormal {margin:0 0 0 0;}#yiv0498113881 o {font-size:0;}#yiv0498113881 #yiv0498113881photos div {float:left;width:72px;}#yiv0498113881 #yiv0498113881photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv0498113881 #yiv0498113881photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0498113881 #yiv0498113881reco-category {font-size:77%;}#yiv0498113881 #yiv0498113881reco-desc {font-size:77%;}#yiv0498113881 .yiv0498113881replbq {margin:4px;}#yiv0498113881 #yiv0498113881ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0498113881 #yiv0498113881ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0498113881 #yiv0498113881ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0498113881 #yiv0498113881ygrp-mlmsg select, #yiv0498113881 input, #yiv0498113881 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0498113881 #yiv0498113881ygrp-mlmsg pre, #yiv0498113881 code {font:115% monospace;}#yiv0498113881 #yiv0498113881ygrp-mlmsg * {line-height:1.22em;}#yiv0498113881 #yiv0498113881ygrp-mlmsg #yiv0498113881logo {padding-bottom:10px;}#yiv0498113881 #yiv0498113881ygrp-msg p a {font-family:Verdana;}#yiv0498113881 #yiv0498113881ygrp-msg p#yiv0498113881attach-count span {color:#1E66AE;font-weight:700;}#yiv0498113881 #yiv0498113881ygrp-reco #yiv0498113881reco-head {color:#ff7900;font-weight:700;}#yiv0498113881 #yiv0498113881ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0498113881 #yiv0498113881ygrp-sponsor #yiv0498113881ov li a {font-size:130%;text-decoration:none;}#yiv0498113881 #yiv0498113881ygrp-sponsor #yiv0498113881ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0498113881 #yiv0498113881ygrp-sponsor #yiv0498113881ov ul {margin:0;padding:0 0 0 8px;}#yiv0498113881 #yiv0498113881ygrp-text {font-family:Georgia;}#yiv0498113881 #yiv0498113881ygrp-text p {margin:0 0 1em 0;}#yiv0498113881 #yiv0498113881ygrp-text tt {font-size:120%;}#yiv0498113881 #yiv0498113881ygrp-vital ul li:last-child {border-right:none !important;}#yiv0498113881

Tue Mar 31, 2015 11:46 pm (PDT) . Posted by:

"Mr. Kid" nmkid.family@ymail.com

Susah juga mencari benda dalam kegelapan ya...
Punya sesuatu yang bisa membuat agak terang dikit masalahnya gak ?

2015-03-24 18:50 GMT+11:00 Dwi Hartanto dwight_oke@yahoo.com.au
[belajar-excel] <belajar-excel@yahoogroups.com>:

>
>
> Salam Guru,
> Saya buat rekam macro dan bagaimana menjalankannya rumus macro tersebut
> sampai data terakhir, karena pada saat dijalankan out of stack selalu pada
> baris ke 180
> Terima kasih
>
>
>

Tue Mar 31, 2015 11:55 pm (PDT) . Posted by:

"ADM PPIC_LSF"

Hello Belajar-excel,

Saya mau tanya caranya menjumlahkan nilai berdasarkan 1 minggu,,,
mohon pencerahan (file terlampir)

terima kasih sebelumnya

by ,, archa

Wed Apr 1, 2015 12:10 am (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai archa,Ini bukan jawaban...tapi klarifikasi pertanyaan,Weeknumber "14" dimulai dari 29 Maret 2015 s/d 4 April 2015 sedangkan 5 April 2015 adalah weeknumber "15".Apakah yang diinginkan adalah menjumlahkan angka yang berada pada weeknumber 14?
Salam,HK
From: "ADM PPIC_LSF wong_camp15@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Wednesday, 1 April 2015, 13:53
Subject: [belajar-excel] Re: Minta tolong [1 Attachment]

  Hello Belajar-excel,

Saya mau tanya caranya menjumlahkan nilai berdasarkan 1 minggu,,,
mohon pencerahan (file terlampir)

terima kasih sebelumnya

by ,, archa #yiv6699520474 #yiv6699520474 -- #yiv6699520474ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6699520474 #yiv6699520474ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6699520474 #yiv6699520474ygrp-mkp #yiv6699520474hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6699520474 #yiv6699520474ygrp-mkp #yiv6699520474ads {margin-bottom:10px;}#yiv6699520474 #yiv6699520474ygrp-mkp .yiv6699520474ad {padding:0 0;}#yiv6699520474 #yiv6699520474ygrp-mkp .yiv6699520474ad p {margin:0;}#yiv6699520474 #yiv6699520474ygrp-mkp .yiv6699520474ad a {color:#0000ff;text-decoration:none;}#yiv6699520474 #yiv6699520474ygrp-sponsor #yiv6699520474ygrp-lc {font-family:Arial;}#yiv6699520474 #yiv6699520474ygrp-sponsor #yiv6699520474ygrp-lc #yiv6699520474hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6699520474 #yiv6699520474ygrp-sponsor #yiv6699520474ygrp-lc .yiv6699520474ad {margin-bottom:10px;padding:0 0;}#yiv6699520474 #yiv6699520474actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6699520474 #yiv6699520474activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6699520474 #yiv6699520474activity span {font-weight:700;}#yiv6699520474 #yiv6699520474activity span:first-child {text-transform:uppercase;}#yiv6699520474 #yiv6699520474activity span a {color:#5085b6;text-decoration:none;}#yiv6699520474 #yiv6699520474activity span span {color:#ff7900;}#yiv6699520474 #yiv6699520474activity span .yiv6699520474underline {text-decoration:underline;}#yiv6699520474 .yiv6699520474attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6699520474 .yiv6699520474attach div a {text-decoration:none;}#yiv6699520474 .yiv6699520474attach img {border:none;padding-right:5px;}#yiv6699520474 .yiv6699520474attach label {display:block;margin-bottom:5px;}#yiv6699520474 .yiv6699520474attach label a {text-decoration:none;}#yiv6699520474 blockquote {margin:0 0 0 4px;}#yiv6699520474 .yiv6699520474bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6699520474 .yiv6699520474bold a {text-decoration:none;}#yiv6699520474 dd.yiv6699520474last p a {font-family:Verdana;font-weight:700;}#yiv6699520474 dd.yiv6699520474last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6699520474 dd.yiv6699520474last p span.yiv6699520474yshortcuts {margin-right:0;}#yiv6699520474 div.yiv6699520474attach-table div div a {text-decoration:none;}#yiv6699520474 div.yiv6699520474attach-table {width:400px;}#yiv6699520474 div.yiv6699520474file-title a, #yiv6699520474 div.yiv6699520474file-title a:active, #yiv6699520474 div.yiv6699520474file-title a:hover, #yiv6699520474 div.yiv6699520474file-title a:visited {text-decoration:none;}#yiv6699520474 div.yiv6699520474photo-title a, #yiv6699520474 div.yiv6699520474photo-title a:active, #yiv6699520474 div.yiv6699520474photo-title a:hover, #yiv6699520474 div.yiv6699520474photo-title a:visited {text-decoration:none;}#yiv6699520474 div#yiv6699520474ygrp-mlmsg #yiv6699520474ygrp-msg p a span.yiv6699520474yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6699520474 .yiv6699520474green {color:#628c2a;}#yiv6699520474 .yiv6699520474MsoNormal {margin:0 0 0 0;}#yiv6699520474 o {font-size:0;}#yiv6699520474 #yiv6699520474photos div {float:left;width:72px;}#yiv6699520474 #yiv6699520474photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv6699520474 #yiv6699520474photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6699520474 #yiv6699520474reco-category {font-size:77%;}#yiv6699520474 #yiv6699520474reco-desc {font-size:77%;}#yiv6699520474 .yiv6699520474replbq {margin:4px;}#yiv6699520474 #yiv6699520474ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6699520474 #yiv6699520474ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6699520474 #yiv6699520474ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6699520474 #yiv6699520474ygrp-mlmsg select, #yiv6699520474 input, #yiv6699520474 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6699520474 #yiv6699520474ygrp-mlmsg pre, #yiv6699520474 code {font:115% monospace;}#yiv6699520474 #yiv6699520474ygrp-mlmsg * {line-height:1.22em;}#yiv6699520474 #yiv6699520474ygrp-mlmsg #yiv6699520474logo {padding-bottom:10px;}#yiv6699520474 #yiv6699520474ygrp-msg p a {font-family:Verdana;}#yiv6699520474 #yiv6699520474ygrp-msg p#yiv6699520474attach-count span {color:#1E66AE;font-weight:700;}#yiv6699520474 #yiv6699520474ygrp-reco #yiv6699520474reco-head {color:#ff7900;font-weight:700;}#yiv6699520474 #yiv6699520474ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6699520474 #yiv6699520474ygrp-sponsor #yiv6699520474ov li a {font-size:130%;text-decoration:none;}#yiv6699520474 #yiv6699520474ygrp-sponsor #yiv6699520474ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6699520474 #yiv6699520474ygrp-sponsor #yiv6699520474ov ul {margin:0;padding:0 0 0 8px;}#yiv6699520474 #yiv6699520474ygrp-text {font-family:Georgia;}#yiv6699520474 #yiv6699520474ygrp-text p {margin:0 0 1em 0;}#yiv6699520474 #yiv6699520474ygrp-text tt {font-size:120%;}#yiv6699520474 #yiv6699520474ygrp-vital ul li:last-child {border-right:none !important;}#yiv6699520474

Wed Apr 1, 2015 12:40 am (PDT) . Posted by:

hai HK,,,

data tsb selama 1 minggu, mulai tgl 30 maret - 5 April ,,, yang saya
pertanyakan bagaimana caranya menjumlahkan nilai selama 1 minggu
tersebut bersadarkan " 1 week"

makasih

salam "archa

On 4/1/2015 2:10 PM, hendrik karnadi hendrikkarnadi@yahoo.com
[belajar-excel] wrote:
> Hai archa,
> Ini bukan jawaban...tapi klarifikasi pertanyaan,
> Weeknumber "14" dimulai dari 29 Maret 2015 s/d 4 April 2015 sedangkan
> 5 April 2015 adalah weeknumber "15".
> Apakah yang diinginkan adalah menjumlahkan angka yang berada pada
> weeknumber 14?
>
> Salam,
> HK
>
> ----------------------------------------------------------
> *From:* "ADM PPIC_LSF wong_camp15@yahoo.com [belajar-excel]"
> <belajar-excel@yahoogroups.com>
> *To:* belajar-excel@yahoogroups.com
> *Sent:* Wednesday, 1 April 2015, 13:53
> *Subject:* [belajar-excel] Re: Minta tolong [1 Attachment]
>
> Hello Belajar-excel,
>
> Saya mau tanya caranya menjumlahkan nilai berdasarkan 1 minggu,,,
> mohon pencerahan (file terlampir)
>
> terima kasih sebelumnya
>
> by ,, archa
>
>
>

Wed Apr 1, 2015 12:41 am (PDT) . Posted by:

prasaja_satria

Selamat siang para master Excel

saya ingin membuat kode macro untuk memfilter data, lalu setelah itu ditiap cell yang terfilter di insert rows. Untuk kode macro filter dan insert rows tidak mengalamai masalah, tetapi yang saya masih bingung yaitu menggerakan cells ke tiap cells yang terpilih (untuk di-insert rows pada perintah berikutnya).

karena yang saya tau sampai saat ini, jika menggunakan perintah offset, maka cells bergerak ke tiap cells termasuk ke cells yang tidak terfilter, sedangkan yang tidak terfilter, tidak akan saya apa apa kan (tidak di insert rows).
kalo menggunakan perintah range().end(xldown), untuk file yang terfilter yang rowsnya bersebelahan, maka akan terlewati.

Berikut saya lampirkan file nya, berikut sheets hasil yang diinginkan, jika penjelasan saya kurang dipahami.

Mohon bantuannya para master, dan terima kasih sebelumnya.





============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com

posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com

berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages

melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/

menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com

keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Tidak ada komentar:

Poskan Komentar