Assalamu'alaikum wr wbMr Kidmaksud saya saya ingin membuat rekap di file
berbeda sheet seperti difilter berdasarkan dua kriteria misal nama tempat dan
bulan di copy ke sheet selnjutnya dan di remove duplikanya tapi menggunakna
macro
begitu mister, .... ini lanjuatn dari email saya yang tanggal 27 maret 2015
sudah di jawab oleh Mister Kid tapi masih ada kendala.terima kasih
Wassalamu'alaikum wr wb
On Wednesday, November 18, 2015 4:21 PM, "'Mr. Kid' mr.nm...@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com> wrote:
Wa'alaikumussalam wr wb
Maaf, tidak mudeng apa yang Anda maksudkan.
Menghapus record yang membuatnya ter-duplicate bisa dengan fitur Remove
Duplicate.
Wassalamu'alaikum wr wb
Kid
On Wed, Nov 18, 2015 at 8:36 AM, imam cahyo yuwono chy...@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:
Assalammualaikum Wr. Wb.
dear BeExceller,saya sudah mencoba beberapa contoh tentang macro ahkan mencoba
menggabung dua contoh tentang menyalin dan menghapus data ganda belum di sort
itu juga tapi yang berfungsi hanya sastu saja gimana ya cara nya
ini contoh yang saya gabungPrivate Sub CommandButton1_Click()Dim Z As LongDim
iPaKolom As LongSet ipaone = Sheets("Sheet1")Set iPaFace = Sheets("Sheet2")Set
UpaOne = ipaone.Range("A1:Z1000")iPaKolom = Range("B1000").End(xlUp).RowFor Z =
iPaKolom To 1 Step -1IfApplication.WorksheetFunction.CountIf(Range("B1:B"
Z),Range("B" Z).Text) > 1 ThenRange("B"
Z).EntireRow.DeleteActiveSheet.Unprotectipaone.Range("A1:Z1").Copy
iPaFace.Range("A1").PasteSpecial Paste:=xlPasteColumnWidthsUpaOne.SpecialCells
_ (xlCellTypeVisible).Copy Destination:=iPaFace.Range("A1")End IfNext
ZEnd Sub
sebaiknya bagai mana menggabung perintah perintah tersebutterima
kasihWassalammualaikum Wr. Wb.
#yiv5112773708 -- #yiv5112773708ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5112773708
#yiv5112773708ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5112773708
#yiv5112773708ygrp-mkp #yiv5112773708hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv5112773708 #yiv5112773708ygrp-mkp #yiv5112773708ads
{margin-bottom:10px;}#yiv5112773708 #yiv5112773708ygrp-mkp .yiv5112773708ad
{padding:0 0;}#yiv5112773708 #yiv5112773708ygrp-mkp .yiv5112773708ad p
{margin:0;}#yiv5112773708 #yiv5112773708ygrp-mkp .yiv5112773708ad a
{color:#0000ff;text-decoration:none;}#yiv5112773708 #yiv5112773708ygrp-sponsor
#yiv5112773708ygrp-lc {font-family:Arial;}#yiv5112773708
#yiv5112773708ygrp-sponsor #yiv5112773708ygrp-lc #yiv5112773708hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5112773708
#yiv5112773708ygrp-sponsor #yiv5112773708ygrp-lc .yiv5112773708ad
{margin-bottom:10px;padding:0 0;}#yiv5112773708 #yiv5112773708actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5112773708
#yiv5112773708activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5112773708
#yiv5112773708activity span {font-weight:700;}#yiv5112773708
#yiv5112773708activity span:first-child
{text-transform:uppercase;}#yiv5112773708 #yiv5112773708activity span a
{color:#5085b6;text-decoration:none;}#yiv5112773708 #yiv5112773708activity span
span {color:#ff7900;}#yiv5112773708 #yiv5112773708activity span
.yiv5112773708underline {text-decoration:underline;}#yiv5112773708
.yiv5112773708attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv5112773708 .yiv5112773708attach div a
{text-decoration:none;}#yiv5112773708 .yiv5112773708attach img
{border:none;padding-right:5px;}#yiv5112773708 .yiv5112773708attach label
{display:block;margin-bottom:5px;}#yiv5112773708 .yiv5112773708attach label a
{text-decoration:none;}#yiv5112773708 blockquote {margin:0 0 0
4px;}#yiv5112773708 .yiv5112773708bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5112773708
.yiv5112773708bold a {text-decoration:none;}#yiv5112773708 dd.yiv5112773708last
p a {font-family:Verdana;font-weight:700;}#yiv5112773708 dd.yiv5112773708last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5112773708
dd.yiv5112773708last p span.yiv5112773708yshortcuts
{margin-right:0;}#yiv5112773708 div.yiv5112773708attach-table div div a
{text-decoration:none;}#yiv5112773708 div.yiv5112773708attach-table
{width:400px;}#yiv5112773708 div.yiv5112773708file-title a, #yiv5112773708
div.yiv5112773708file-title a:active, #yiv5112773708
div.yiv5112773708file-title a:hover, #yiv5112773708 div.yiv5112773708file-title
a:visited {text-decoration:none;}#yiv5112773708 div.yiv5112773708photo-title a,
#yiv5112773708 div.yiv5112773708photo-title a:active, #yiv5112773708
div.yiv5112773708photo-title a:hover, #yiv5112773708
div.yiv5112773708photo-title a:visited {text-decoration:none;}#yiv5112773708
div#yiv5112773708ygrp-mlmsg #yiv5112773708ygrp-msg p a
span.yiv5112773708yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5112773708
.yiv5112773708green {color:#628c2a;}#yiv5112773708 .yiv5112773708MsoNormal
{margin:0 0 0 0;}#yiv5112773708 o {font-size:0;}#yiv5112773708
#yiv5112773708photos div {float:left;width:72px;}#yiv5112773708
#yiv5112773708photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv5112773708
#yiv5112773708photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5112773708
#yiv5112773708reco-category {font-size:77%;}#yiv5112773708
#yiv5112773708reco-desc {font-size:77%;}#yiv5112773708 .yiv5112773708replbq
{margin:4px;}#yiv5112773708 #yiv5112773708ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv5112773708 #yiv5112773708ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5112773708
#yiv5112773708ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5112773708
#yiv5112773708ygrp-mlmsg select, #yiv5112773708 input, #yiv5112773708 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv5112773708
#yiv5112773708ygrp-mlmsg pre, #yiv5112773708 code {font:115%
monospace;}#yiv5112773708 #yiv5112773708ygrp-mlmsg *
{line-height:1.22em;}#yiv5112773708 #yiv5112773708ygrp-mlmsg #yiv5112773708logo
{padding-bottom:10px;}#yiv5112773708 #yiv5112773708ygrp-msg p a
{font-family:Verdana;}#yiv5112773708 #yiv5112773708ygrp-msg
p#yiv5112773708attach-count span {color:#1E66AE;font-weight:700;}#yiv5112773708
#yiv5112773708ygrp-reco #yiv5112773708reco-head
{color:#ff7900;font-weight:700;}#yiv5112773708 #yiv5112773708ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv5112773708 #yiv5112773708ygrp-sponsor
#yiv5112773708ov li a {font-size:130%;text-decoration:none;}#yiv5112773708
#yiv5112773708ygrp-sponsor #yiv5112773708ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv5112773708
#yiv5112773708ygrp-sponsor #yiv5112773708ov ul {margin:0;padding:0 0 0
8px;}#yiv5112773708 #yiv5112773708ygrp-text
{font-family:Georgia;}#yiv5112773708 #yiv5112773708ygrp-text p {margin:0 0 1em
0;}#yiv5112773708 #yiv5112773708ygrp-text tt {font-size:120%;}#yiv5112773708
#yiv5112773708ygrp-vital ul li:last-child {border-right:none
!important;}#yiv5112773708
