Re: [belajar-excel] Rumus untuk gaji pokok
pak ahmadcoba pakai SUMPRODUCT, dengan sedikit penyesuaian di tabel gaji pokok. Pada Rabu, 29 Januari 2020 14.44.32 GMT+7, Ahmad Muzaeni ahmadmuzaen...@yahoo.co.id [belajar-excel] menulis: Adakah yang bisa bantu ?bagaimana rumus untuk gaji pokok pegawai berdasarkan pangkat golongan dan masa kerja ? Terima kasih sebelumnya #yiv0241390457 #yiv0241390457 -- #yiv0241390457ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0241390457 #yiv0241390457ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0241390457 #yiv0241390457ygrp-mkp #yiv0241390457hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0241390457 #yiv0241390457ygrp-mkp #yiv0241390457ads {margin-bottom:10px;}#yiv0241390457 #yiv0241390457ygrp-mkp .yiv0241390457ad {padding:0 0;}#yiv0241390457 #yiv0241390457ygrp-mkp .yiv0241390457ad p {margin:0;}#yiv0241390457 #yiv0241390457ygrp-mkp .yiv0241390457ad a {color:#ff;text-decoration:none;}#yiv0241390457 #yiv0241390457ygrp-sponsor #yiv0241390457ygrp-lc {font-family:Arial;}#yiv0241390457 #yiv0241390457ygrp-sponsor #yiv0241390457ygrp-lc #yiv0241390457hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0241390457 #yiv0241390457ygrp-sponsor #yiv0241390457ygrp-lc .yiv0241390457ad {margin-bottom:10px;padding:0 0;}#yiv0241390457 #yiv0241390457actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0241390457 #yiv0241390457activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0241390457 #yiv0241390457activity span {font-weight:700;}#yiv0241390457 #yiv0241390457activity span:first-child {text-transform:uppercase;}#yiv0241390457 #yiv0241390457activity span a {color:#5085b6;text-decoration:none;}#yiv0241390457 #yiv0241390457activity span span {color:#ff7900;}#yiv0241390457 #yiv0241390457activity span .yiv0241390457underline {text-decoration:underline;}#yiv0241390457 .yiv0241390457attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0241390457 .yiv0241390457attach div a {text-decoration:none;}#yiv0241390457 .yiv0241390457attach img {border:none;padding-right:5px;}#yiv0241390457 .yiv0241390457attach label {display:block;margin-bottom:5px;}#yiv0241390457 .yiv0241390457attach label a {text-decoration:none;}#yiv0241390457 blockquote {margin:0 0 0 4px;}#yiv0241390457 .yiv0241390457bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0241390457 .yiv0241390457bold a {text-decoration:none;}#yiv0241390457 dd.yiv0241390457last p a {font-family:Verdana;font-weight:700;}#yiv0241390457 dd.yiv0241390457last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0241390457 dd.yiv0241390457last p span.yiv0241390457yshortcuts {margin-right:0;}#yiv0241390457 div.yiv0241390457attach-table div div a {text-decoration:none;}#yiv0241390457 div.yiv0241390457attach-table {width:400px;}#yiv0241390457 div.yiv0241390457file-title a, #yiv0241390457 div.yiv0241390457file-title a:active, #yiv0241390457 div.yiv0241390457file-title a:hover, #yiv0241390457 div.yiv0241390457file-title a:visited {text-decoration:none;}#yiv0241390457 div.yiv0241390457photo-title a, #yiv0241390457 div.yiv0241390457photo-title a:active, #yiv0241390457 div.yiv0241390457photo-title a:hover, #yiv0241390457 div.yiv0241390457photo-title a:visited {text-decoration:none;}#yiv0241390457 div#yiv0241390457ygrp-mlmsg #yiv0241390457ygrp-msg p a span.yiv0241390457yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0241390457 .yiv0241390457green {color:#628c2a;}#yiv0241390457 .yiv0241390457MsoNormal {margin:0 0 0 0;}#yiv0241390457 o {font-size:0;}#yiv0241390457 #yiv0241390457photos div {float:left;width:72px;}#yiv0241390457 #yiv0241390457photos div div {border:1px solid #66;min-height:62px;overflow:hidden;width:62px;}#yiv0241390457 #yiv0241390457photos div label {color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0241390457 #yiv0241390457reco-category {font-size:77%;}#yiv0241390457 #yiv0241390457reco-desc {font-size:77%;}#yiv0241390457 .yiv0241390457replbq {margin:4px;}#yiv0241390457 #yiv0241390457ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0241390457 #yiv0241390457ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0241390457 #yiv0241390457ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0241390457 #yiv0241390457ygrp-mlmsg select, #yiv0241390457 input, #yiv0241390457 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0241390457 #yiv0241390457ygrp-mlmsg pre, #yiv0241390457 code {font:115% monospace;}#yiv0241390457 #yiv0241390457ygrp-mlmsg * {line-height:1.22em;}#yiv0241390457 #yiv0241390457ygrp-mlmsg #yiv0241390457logo {padding-bottom:10px;}#yiv0241390457 #yiv0241390457ygrp-msg p a {font-family:Verdana;}#yiv0241390457 #yiv0241390457ygrp-msg p#yiv0241390457attach-count
Re: [belajar-excel] Formula Tanggal
bisa juga seting bahasa di sistim tidak sama dengan seting bahasa di komputer. Pada Minggu, 2 Februari 2020 19.22.46 WIB, halak hita halakhita1...@gmail.com [belajar-excel] menulis: Dear para Master Excel Saya Export data dari sistim, kemudian tanggal nya menjadi Text. Tolong dibantu formula yang tepat untuk data berikut sebab menggunakan Datevalue beberapa berhasil namun ada yg value. SalamHH #yiv0922913398 #yiv0922913398 -- #yiv0922913398ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0922913398 #yiv0922913398ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0922913398 #yiv0922913398ygrp-mkp #yiv0922913398hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0922913398 #yiv0922913398ygrp-mkp #yiv0922913398ads {margin-bottom:10px;}#yiv0922913398 #yiv0922913398ygrp-mkp .yiv0922913398ad {padding:0 0;}#yiv0922913398 #yiv0922913398ygrp-mkp .yiv0922913398ad p {margin:0;}#yiv0922913398 #yiv0922913398ygrp-mkp .yiv0922913398ad a {color:#ff;text-decoration:none;}#yiv0922913398 #yiv0922913398ygrp-sponsor #yiv0922913398ygrp-lc {font-family:Arial;}#yiv0922913398 #yiv0922913398ygrp-sponsor #yiv0922913398ygrp-lc #yiv0922913398hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0922913398 #yiv0922913398ygrp-sponsor #yiv0922913398ygrp-lc .yiv0922913398ad {margin-bottom:10px;padding:0 0;}#yiv0922913398 #yiv0922913398actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0922913398 #yiv0922913398activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0922913398 #yiv0922913398activity span {font-weight:700;}#yiv0922913398 #yiv0922913398activity span:first-child {text-transform:uppercase;}#yiv0922913398 #yiv0922913398activity span a {color:#5085b6;text-decoration:none;}#yiv0922913398 #yiv0922913398activity span span {color:#ff7900;}#yiv0922913398 #yiv0922913398activity span .yiv0922913398underline {text-decoration:underline;}#yiv0922913398 .yiv0922913398attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0922913398 .yiv0922913398attach div a {text-decoration:none;}#yiv0922913398 .yiv0922913398attach img {border:none;padding-right:5px;}#yiv0922913398 .yiv0922913398attach label {display:block;margin-bottom:5px;}#yiv0922913398 .yiv0922913398attach label a {text-decoration:none;}#yiv0922913398 blockquote {margin:0 0 0 4px;}#yiv0922913398 .yiv0922913398bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0922913398 .yiv0922913398bold a {text-decoration:none;}#yiv0922913398 dd.yiv0922913398last p a {font-family:Verdana;font-weight:700;}#yiv0922913398 dd.yiv0922913398last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0922913398 dd.yiv0922913398last p span.yiv0922913398yshortcuts {margin-right:0;}#yiv0922913398 div.yiv0922913398attach-table div div a {text-decoration:none;}#yiv0922913398 div.yiv0922913398attach-table {width:400px;}#yiv0922913398 div.yiv0922913398file-title a, #yiv0922913398 div.yiv0922913398file-title a:active, #yiv0922913398 div.yiv0922913398file-title a:hover, #yiv0922913398 div.yiv0922913398file-title a:visited {text-decoration:none;}#yiv0922913398 div.yiv0922913398photo-title a, #yiv0922913398 div.yiv0922913398photo-title a:active, #yiv0922913398 div.yiv0922913398photo-title a:hover, #yiv0922913398 div.yiv0922913398photo-title a:visited {text-decoration:none;}#yiv0922913398 div#yiv0922913398ygrp-mlmsg #yiv0922913398ygrp-msg p a span.yiv0922913398yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0922913398 .yiv0922913398green {color:#628c2a;}#yiv0922913398 .yiv0922913398MsoNormal {margin:0 0 0 0;}#yiv0922913398 o {font-size:0;}#yiv0922913398 #yiv0922913398photos div {float:left;width:72px;}#yiv0922913398 #yiv0922913398photos div div {border:1px solid #66;min-height:62px;overflow:hidden;width:62px;}#yiv0922913398 #yiv0922913398photos div label {color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0922913398 #yiv0922913398reco-category {font-size:77%;}#yiv0922913398 #yiv0922913398reco-desc {font-size:77%;}#yiv0922913398 .yiv0922913398replbq {margin:4px;}#yiv0922913398 #yiv0922913398ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0922913398 #yiv0922913398ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0922913398 #yiv0922913398ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0922913398 #yiv0922913398ygrp-mlmsg select, #yiv0922913398 input, #yiv0922913398 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0922913398 #yiv0922913398ygrp-mlmsg pre, #yiv0922913398 code {font:115% monospace;}#yiv0922913398 #yiv0922913398ygrp-mlmsg * {line-height:1.22em;}#yiv0922913398 #yiv0922913398ygrp-mlmsg #yiv0922913398logo {padding-bottom:10px;}#yiv0922913398 #yiv0922913398ygrp-msg p a
Re: [belajar-excel] Mengcopy data dari file berbeda menggunakan vba
Hai Heru, Coba lakukan rekaman macro. Langkah2 nya kira2 begini:- Buka file Tujuan- Buka Menu Macro Recording- Buka file sumber- Copy range dari file Sumber.- Kembali ke file Tujuan, klik range tujuan- Klik kanan mouse, pilih paste- Kembali ke file Sumber- Tutup file Sumber- Stop Macro Recording. Coba lihat hasil rekaman macro dengan menekan tombol Alt+F11 secara bersamaan. Salam,HK Sent from Yahoo Mail on Android On Fri, Feb 7, 2020 at 10:12, Heru Adi hr_a...@yahoo.com [belajar-excel] wrote: Assalamu'alaikum. Mohon bantuannya teman2 semua, bagaimana cara mengcopy data dari file excel yg berbeda menggunakan code macro. Sebelumnya saya ucapkan terimakasih banyak :) Wassalamu'alaikum. Best Regards,Heru Adi S Dikirim dari Yahoo Mail di Android #yiv6707300043 #yiv6707300043 -- #yiv6707300043ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6707300043 #yiv6707300043ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6707300043 #yiv6707300043ygrp-mkp #yiv6707300043hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6707300043 #yiv6707300043ygrp-mkp #yiv6707300043ads {margin-bottom:10px;}#yiv6707300043 #yiv6707300043ygrp-mkp .yiv6707300043ad {padding:0 0;}#yiv6707300043 #yiv6707300043ygrp-mkp .yiv6707300043ad p {margin:0;}#yiv6707300043 #yiv6707300043ygrp-mkp .yiv6707300043ad a {color:#ff;text-decoration:none;}#yiv6707300043 #yiv6707300043ygrp-sponsor #yiv6707300043ygrp-lc {font-family:Arial;}#yiv6707300043 #yiv6707300043ygrp-sponsor #yiv6707300043ygrp-lc #yiv6707300043hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6707300043 #yiv6707300043ygrp-sponsor #yiv6707300043ygrp-lc .yiv6707300043ad {margin-bottom:10px;padding:0 0;}#yiv6707300043 #yiv6707300043actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6707300043 #yiv6707300043activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6707300043 #yiv6707300043activity span {font-weight:700;}#yiv6707300043 #yiv6707300043activity span:first-child {text-transform:uppercase;}#yiv6707300043 #yiv6707300043activity span a {color:#5085b6;text-decoration:none;}#yiv6707300043 #yiv6707300043activity span span {color:#ff7900;}#yiv6707300043 #yiv6707300043activity span .yiv6707300043underline {text-decoration:underline;}#yiv6707300043 .yiv6707300043attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6707300043 .yiv6707300043attach div a {text-decoration:none;}#yiv6707300043 .yiv6707300043attach img {border:none;padding-right:5px;}#yiv6707300043 .yiv6707300043attach label {display:block;margin-bottom:5px;}#yiv6707300043 .yiv6707300043attach label a {text-decoration:none;}#yiv6707300043 blockquote {margin:0 0 0 4px;}#yiv6707300043 .yiv6707300043bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6707300043 .yiv6707300043bold a {text-decoration:none;}#yiv6707300043 dd.yiv6707300043last p a {font-family:Verdana;font-weight:700;}#yiv6707300043 dd.yiv6707300043last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6707300043 dd.yiv6707300043last p span.yiv6707300043yshortcuts {margin-right:0;}#yiv6707300043 div.yiv6707300043attach-table div div a {text-decoration:none;}#yiv6707300043 div.yiv6707300043attach-table {width:400px;}#yiv6707300043 div.yiv6707300043file-title a, #yiv6707300043 div.yiv6707300043file-title a:active, #yiv6707300043 div.yiv6707300043file-title a:hover, #yiv6707300043 div.yiv6707300043file-title a:visited {text-decoration:none;}#yiv6707300043 div..yiv6707300043photo-title a, #yiv6707300043 div.yiv6707300043photo-title a:active, #yiv6707300043 div.yiv6707300043photo-title a:hover, #yiv6707300043 div.yiv6707300043photo-title a:visited {text-decoration:none;}#yiv6707300043 div#yiv6707300043ygrp-mlmsg #yiv6707300043ygrp-msg p a span.yiv6707300043yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6707300043 .yiv6707300043green {color:#628c2a;}#yiv6707300043 .yiv6707300043MsoNormal {margin:0 0 0 0;}#yiv6707300043 o {font-size:0;}#yiv6707300043 #yiv6707300043photos div {float:left;width:72px;}#yiv6707300043 #yiv6707300043photos div div {border:1px solid #66;min-height:62px;overflow:hidden;width:62px;}#yiv6707300043 #yiv6707300043photos div label {color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6707300043 #yiv6707300043reco-category {font-size:77%;}#yiv6707300043 #yiv6707300043reco-desc {font-size:77%;}#yiv6707300043 .yiv6707300043replbq {margin:4px;}#yiv6707300043 #yiv6707300043ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6707300043 #yiv6707300043ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6707300043 #yiv6707300043ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6707300043 #yiv6707300043ygrp-mlmsg select, #yiv6707300043 input, #yiv6707300043
[belajar-excel] Mengcopy data dari file berbeda menggunakan vba
Assalamu'alaikum. Mohon bantuannya teman2 semua, bagaimana cara mengcopy data dari file excel yg berbeda menggunakan code macro. Sebelumnya saya ucapkan terimakasih banyak :) Wassalamu'alaikum. Best Regards,Heru Adi S Dikirim dari Yahoo Mail di Android