Dear Mr Kid,
Terima kasih atas ilmunya, sangat2 membantu saya.Tetapi ada beberapa permasalah
yang mengikutinya.1. Untuk daftar Bundel Nota, jika dipergunakan untuk 2 atau
lebih printer tidak bisa.2. Ada Kalanya Bandel Nota No nya tidak tentu,
sehingga "KODE NOTA" menjadi tidak bisa tampil, karena proses pengambilan
Bundel Nota tidak beraturan.3. Untuk Tabel Daftar Bundel Nota, harus Full Diisi
data, jika tidak (atau data masih kosong) hasilnya di No Nota Awal pada printer
menjadi 1.
Mohon masukannya.
Regardsketut
On Monday, 4 March 2019, 12:41:36 pm GMT+8, 'Mr. Kid' [email protected]
[belajar-excel] <[email protected]> wrote:file terlampir dengan tabel referensi yang lebih detil agar memiliki relasi dengan data. On Sat, Mar 2, 2019 at 11:01 AM ketut budiasa [email protected] [belajar-excel] <[email protected]> wrote: Dear All, Minta bantuan untuk menentukan no nota yang sudah dipergunakan.Kita menggunakan No yang sudah ada no SerinyaTiap Bundle Nota, terdapat 2000 Nota ( berserta no Serinya )Masing-masing bundle Nota ada kodenya.Setiap hari penggunakan Nota tidak tentu.Jadi masalah pada saat ada pergantian Bundel Nota di Pertengahan Hari.Sehingga NO Seri di Nota Berikutnya tidak bisa otomatis.Mungkin bisa dibantu seprti dalam table berikut RegardsKetut #yiv9215110590 #yiv9215110590 -- #yiv9215110590ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9215110590 #yiv9215110590ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9215110590 #yiv9215110590ygrp-mkp #yiv9215110590hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9215110590 #yiv9215110590ygrp-mkp #yiv9215110590ads {margin-bottom:10px;}#yiv9215110590 #yiv9215110590ygrp-mkp .yiv9215110590ad {padding:0 0;}#yiv9215110590 #yiv9215110590ygrp-mkp .yiv9215110590ad p {margin:0;}#yiv9215110590 #yiv9215110590ygrp-mkp .yiv9215110590ad a {color:#0000ff;text-decoration:none;}#yiv9215110590 #yiv9215110590ygrp-sponsor #yiv9215110590ygrp-lc {font-family:Arial;}#yiv9215110590 #yiv9215110590ygrp-sponsor #yiv9215110590ygrp-lc #yiv9215110590hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9215110590 #yiv9215110590ygrp-sponsor #yiv9215110590ygrp-lc .yiv9215110590ad {margin-bottom:10px;padding:0 0;}#yiv9215110590 #yiv9215110590actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9215110590 #yiv9215110590activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9215110590 #yiv9215110590activity span {font-weight:700;}#yiv9215110590 #yiv9215110590activity span:first-child {text-transform:uppercase;}#yiv9215110590 #yiv9215110590activity span a {color:#5085b6;text-decoration:none;}#yiv9215110590 #yiv9215110590activity span span {color:#ff7900;}#yiv9215110590 #yiv9215110590activity span .yiv9215110590underline {text-decoration:underline;}#yiv9215110590 .yiv9215110590attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9215110590 .yiv9215110590attach div a {text-decoration:none;}#yiv9215110590 .yiv9215110590attach img {border:none;padding-right:5px;}#yiv9215110590 .yiv9215110590attach label {display:block;margin-bottom:5px;}#yiv9215110590 .yiv9215110590attach label a {text-decoration:none;}#yiv9215110590 blockquote {margin:0 0 0 4px;}#yiv9215110590 .yiv9215110590bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9215110590 .yiv9215110590bold a {text-decoration:none;}#yiv9215110590 dd.yiv9215110590last p a {font-family:Verdana;font-weight:700;}#yiv9215110590 dd.yiv9215110590last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9215110590 dd.yiv9215110590last p span...yiv9215110590yshortcuts {margin-right:0;}#yiv9215110590 div.yiv9215110590attach-table div div a {text-decoration:none;}#yiv9215110590 div.yiv9215110590attach-table {width:400px;}#yiv9215110590 div.yiv9215110590file-title a, #yiv9215110590 div.yiv9215110590file-title a:active, #yiv9215110590 div.yiv9215110590file-title a:hover, #yiv9215110590 div.yiv9215110590file-title a:visited {text-decoration:none;}#yiv9215110590 div.yiv9215110590photo-title a, #yiv9215110590 div.yiv9215110590photo-title a:active, #yiv9215110590 div...yiv9215110590photo-title a:hover, #yiv9215110590 div.yiv9215110590photo-title a:visited {text-decoration:none;}#yiv9215110590 div#yiv9215110590ygrp-mlmsg #yiv9215110590ygrp-msg p a span.yiv9215110590yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9215110590 .yiv9215110590green {color:#628c2a;}#yiv9215110590 .yiv9215110590MsoNormal {margin:0 0 0 0;}#yiv9215110590 o {font-size:0;}#yiv9215110590 #yiv9215110590photos div {float:left;width:72px;}#yiv9215110590 #yiv9215110590photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv9215110590 #yiv9215110590photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9215110590 #yiv9215110590reco-category {font-size:77%;}#yiv9215110590 #yiv9215110590reco-desc {font-size:77%;}#yiv9215110590 .yiv9215110590replbq {margin:4px;}#yiv9215110590 #yiv9215110590ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9215110590 #yiv9215110590ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9215110590 #yiv9215110590ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9215110590 #yiv9215110590ygrp-mlmsg select, #yiv9215110590 input, #yiv9215110590 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9215110590 #yiv9215110590ygrp-mlmsg pre, #yiv9215110590 code {font:115% monospace;}#yiv9215110590 #yiv9215110590ygrp-mlmsg * {line-height:1.22em;}#yiv9215110590 #yiv9215110590ygrp-mlmsg #yiv9215110590logo {padding-bottom:10px;}#yiv9215110590 #yiv9215110590ygrp-msg p a {font-family:Verdana;}#yiv9215110590 #yiv9215110590ygrp-msg p#yiv9215110590attach-count span {color:#1E66AE;font-weight:700;}#yiv9215110590 #yiv9215110590ygrp-reco #yiv9215110590reco-head {color:#ff7900;font-weight:700;}#yiv9215110590 #yiv9215110590ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9215110590 #yiv9215110590ygrp-sponsor #yiv9215110590ov li a {font-size:130%;text-decoration:none;}#yiv9215110590 #yiv9215110590ygrp-sponsor #yiv9215110590ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9215110590 #yiv9215110590ygrp-sponsor #yiv9215110590ov ul {margin:0;padding:0 0 0 8px;}#yiv9215110590 #yiv9215110590ygrp-text {font-family:Georgia;}#yiv9215110590 #yiv9215110590ygrp-text p {margin:0 0 1em 0;}#yiv9215110590 #yiv9215110590ygrp-text tt {font-size:120%;}#yiv9215110590 #yiv9215110590ygrp-vital ul li:last-child {border-right:none !important;}#yiv9215110590
re-TABEL PENGGUNAAN NOTA.xlsx
Description: MS-Excel 2007 spreadsheet
