Dear Samsudin, Saya coba dengan menggunakan VBA.(Hapus semua no. Registrasi kemudian click tombol "CHECK")Semoga membantu.. TerimaKasih,
Pada Selasa, 29 November 2016 16:50, "Susilo - [email protected]
[belajar-excel]" <[email protected]> menulis:
Dear sam
Saya menambahkan 2 kolom ID untuk mengurutkan tanggalnyaMungkin rekan-rekan ada
yang bisa membantu untuk lebih menyederhanakan lagi
Silakan merujuk pada attachment file berikut
Terima kasihSusilo
Pada 29 November 2016 15.15, Samsudin Sam [email protected]
[belajar-excel] <[email protected]> menulis:
Master Excel yth,
mohon bantuan dan pencerahannya untuk masalah yang saya hadapi, rencananya saya
ingin membuat no urut registrasi, no urut ini dimulai dari control no yang
datang di site pertama/berdasarkan data on site. berikut saya sudah mencoba
membuatnya tetapi menggunakan step8 (sheet1,cell l3:24), apakah ada yang bisa
membantu untuk masalah ini yang lebih praktis lagi.
terima kasih
samsudin
#yiv2473183595 #yiv2473183595 -- #yiv2473183595ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2473183595
#yiv2473183595ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2473183595
#yiv2473183595ygrp-mkp #yiv2473183595hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2473183595 #yiv2473183595ygrp-mkp #yiv2473183595ads
{margin-bottom:10px;}#yiv2473183595 #yiv2473183595ygrp-mkp .yiv2473183595ad
{padding:0 0;}#yiv2473183595 #yiv2473183595ygrp-mkp .yiv2473183595ad p
{margin:0;}#yiv2473183595 #yiv2473183595ygrp-mkp .yiv2473183595ad a
{color:#0000ff;text-decoration:none;}#yiv2473183595 #yiv2473183595ygrp-sponsor
#yiv2473183595ygrp-lc {font-family:Arial;}#yiv2473183595
#yiv2473183595ygrp-sponsor #yiv2473183595ygrp-lc #yiv2473183595hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2473183595
#yiv2473183595ygrp-sponsor #yiv2473183595ygrp-lc .yiv2473183595ad
{margin-bottom:10px;padding:0 0;}#yiv2473183595 #yiv2473183595actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2473183595
#yiv2473183595activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2473183595
#yiv2473183595activity span {font-weight:700;}#yiv2473183595
#yiv2473183595activity span:first-child
{text-transform:uppercase;}#yiv2473183595 #yiv2473183595activity span a
{color:#5085b6;text-decoration:none;}#yiv2473183595 #yiv2473183595activity span
span {color:#ff7900;}#yiv2473183595 #yiv2473183595activity span
.yiv2473183595underline {text-decoration:underline;}#yiv2473183595
.yiv2473183595attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2473183595 .yiv2473183595attach div a
{text-decoration:none;}#yiv2473183595 .yiv2473183595attach img
{border:none;padding-right:5px;}#yiv2473183595 .yiv2473183595attach label
{display:block;margin-bottom:5px;}#yiv2473183595 .yiv2473183595attach label a
{text-decoration:none;}#yiv2473183595 blockquote {margin:0 0 0
4px;}#yiv2473183595 .yiv2473183595bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2473183595
.yiv2473183595bold a {text-decoration:none;}#yiv2473183595 dd.yiv2473183595last
p a {font-family:Verdana;font-weight:700;}#yiv2473183595 dd.yiv2473183595last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2473183595
dd.yiv2473183595last p span.yiv2473183595yshortcuts
{margin-right:0;}#yiv2473183595 div.yiv2473183595attach-table div div a
{text-decoration:none;}#yiv2473183595 div.yiv2473183595attach-table
{width:400px;}#yiv2473183595 div.yiv2473183595file-title a, #yiv2473183595
div.yiv2473183595file-title a:active, #yiv2473183595
div.yiv2473183595file-title a:hover, #yiv2473183595 div.yiv2473183595file-title
a:visited {text-decoration:none;}#yiv2473183595 div.yiv2473183595photo-title a,
#yiv2473183595 div.yiv2473183595photo-title a:active, #yiv2473183595
div.yiv2473183595photo-title a:hover, #yiv2473183595
div.yiv2473183595photo-title a:visited {text-decoration:none;}#yiv2473183595
div#yiv2473183595ygrp-mlmsg #yiv2473183595ygrp-msg p a
span.yiv2473183595yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2473183595
.yiv2473183595green {color:#628c2a;}#yiv2473183595 .yiv2473183595MsoNormal
{margin:0 0 0 0;}#yiv2473183595 o {font-size:0;}#yiv2473183595
#yiv2473183595photos div {float:left;width:72px;}#yiv2473183595
#yiv2473183595photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv2473183595
#yiv2473183595photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2473183595
#yiv2473183595reco-category {font-size:77%;}#yiv2473183595
#yiv2473183595reco-desc {font-size:77%;}#yiv2473183595 .yiv2473183595replbq
{margin:4px;}#yiv2473183595 #yiv2473183595ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv2473183595 #yiv2473183595ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2473183595
#yiv2473183595ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2473183595
#yiv2473183595ygrp-mlmsg select, #yiv2473183595 input, #yiv2473183595 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2473183595
#yiv2473183595ygrp-mlmsg pre, #yiv2473183595 code {font:115%
monospace;}#yiv2473183595 #yiv2473183595ygrp-mlmsg *
{line-height:1.22em;}#yiv2473183595 #yiv2473183595ygrp-mlmsg #yiv2473183595logo
{padding-bottom:10px;}#yiv2473183595 #yiv2473183595ygrp-msg p a
{font-family:Verdana;}#yiv2473183595 #yiv2473183595ygrp-msg
p#yiv2473183595attach-count span {color:#1E66AE;font-weight:700;}#yiv2473183595
#yiv2473183595ygrp-reco #yiv2473183595reco-head
{color:#ff7900;font-weight:700;}#yiv2473183595 #yiv2473183595ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv2473183595 #yiv2473183595ygrp-sponsor
#yiv2473183595ov li a {font-size:130%;text-decoration:none;}#yiv2473183595
#yiv2473183595ygrp-sponsor #yiv2473183595ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv2473183595
#yiv2473183595ygrp-sponsor #yiv2473183595ov ul {margin:0;padding:0 0 0
8px;}#yiv2473183595 #yiv2473183595ygrp-text
{font-family:Georgia;}#yiv2473183595 #yiv2473183595ygrp-text p {margin:0 0 1em
0;}#yiv2473183595 #yiv2473183595ygrp-text tt {font-size:120%;}#yiv2473183595
#yiv2473183595ygrp-vital ul li:last-child {border-right:none
!important;}#yiv2473183595
Registrasi Equipment_1.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
