Hai Shilvya,Coba dijabarkan proses manualnya dan contoh format input/output
yang diinginkan serta penjelasannya dalam sheet2 di Excel.
Salam,HK
From: "Shilvya mayda Dwinanda [email protected] [belajar-excel]"
<[email protected]>
To: [email protected]
Sent: Wednesday, 11 March 2015, 14:47
Subject: [belajar-excel] rekap invoice dan surat jalan
Assalamu'alaikum wr wb
Nama Saya shilvya mayda ...saya bekerja di salah satu perusahaan , kebetulan di
perusahaan kami masih baru dan belum ada sistem untuk rekapitulasi data .saya
di beri tugas untuk membuat rekapitulasi data invoice dan surat jalan yang
saling terhubung satu sama lain , agar jika di find data langsung terhubung
ketika barang datang dan tagihan masuk .tolong bimbingannya dari awal,, saya
masih belum begitu faham dengan excel lebih jauh .hanya excel umum dan rekap
yang baru saya buat masih menggunakan sistem manual.
terimakasih ,,
wassalamu'alaikum wr wb
#yiv5326624280 #yiv5326624280 -- #yiv5326624280ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5326624280
#yiv5326624280ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5326624280
#yiv5326624280ygrp-mkp #yiv5326624280hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv5326624280 #yiv5326624280ygrp-mkp #yiv5326624280ads
{margin-bottom:10px;}#yiv5326624280 #yiv5326624280ygrp-mkp .yiv5326624280ad
{padding:0 0;}#yiv5326624280 #yiv5326624280ygrp-mkp .yiv5326624280ad p
{margin:0;}#yiv5326624280 #yiv5326624280ygrp-mkp .yiv5326624280ad a
{color:#0000ff;text-decoration:none;}#yiv5326624280 #yiv5326624280ygrp-sponsor
#yiv5326624280ygrp-lc {font-family:Arial;}#yiv5326624280
#yiv5326624280ygrp-sponsor #yiv5326624280ygrp-lc #yiv5326624280hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5326624280
#yiv5326624280ygrp-sponsor #yiv5326624280ygrp-lc .yiv5326624280ad
{margin-bottom:10px;padding:0 0;}#yiv5326624280 #yiv5326624280actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5326624280
#yiv5326624280activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5326624280
#yiv5326624280activity span {font-weight:700;}#yiv5326624280
#yiv5326624280activity span:first-child
{text-transform:uppercase;}#yiv5326624280 #yiv5326624280activity span a
{color:#5085b6;text-decoration:none;}#yiv5326624280 #yiv5326624280activity span
span {color:#ff7900;}#yiv5326624280 #yiv5326624280activity span
.yiv5326624280underline {text-decoration:underline;}#yiv5326624280
.yiv5326624280attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv5326624280 .yiv5326624280attach div a
{text-decoration:none;}#yiv5326624280 .yiv5326624280attach img
{border:none;padding-right:5px;}#yiv5326624280 .yiv5326624280attach label
{display:block;margin-bottom:5px;}#yiv5326624280 .yiv5326624280attach label a
{text-decoration:none;}#yiv5326624280 blockquote {margin:0 0 0
4px;}#yiv5326624280 .yiv5326624280bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5326624280
.yiv5326624280bold a {text-decoration:none;}#yiv5326624280 dd.yiv5326624280last
p a {font-family:Verdana;font-weight:700;}#yiv5326624280 dd.yiv5326624280last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5326624280
dd.yiv5326624280last p span.yiv5326624280yshortcuts
{margin-right:0;}#yiv5326624280 div.yiv5326624280attach-table div div a
{text-decoration:none;}#yiv5326624280 div.yiv5326624280attach-table
{width:400px;}#yiv5326624280 div.yiv5326624280file-title a, #yiv5326624280
div.yiv5326624280file-title a:active, #yiv5326624280
div.yiv5326624280file-title a:hover, #yiv5326624280 div.yiv5326624280file-title
a:visited {text-decoration:none;}#yiv5326624280 div.yiv5326624280photo-title a,
#yiv5326624280 div.yiv5326624280photo-title a:active, #yiv5326624280
div.yiv5326624280photo-title a:hover, #yiv5326624280
div.yiv5326624280photo-title a:visited {text-decoration:none;}#yiv5326624280
div#yiv5326624280ygrp-mlmsg #yiv5326624280ygrp-msg p a
span.yiv5326624280yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5326624280
.yiv5326624280green {color:#628c2a;}#yiv5326624280 .yiv5326624280MsoNormal
{margin:0 0 0 0;}#yiv5326624280 o {font-size:0;}#yiv5326624280
#yiv5326624280photos div {float:left;width:72px;}#yiv5326624280
#yiv5326624280photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv5326624280
#yiv5326624280photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5326624280
#yiv5326624280reco-category {font-size:77%;}#yiv5326624280
#yiv5326624280reco-desc {font-size:77%;}#yiv5326624280 .yiv5326624280replbq
{margin:4px;}#yiv5326624280 #yiv5326624280ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv5326624280 #yiv5326624280ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5326624280
#yiv5326624280ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5326624280
#yiv5326624280ygrp-mlmsg select, #yiv5326624280 input, #yiv5326624280 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv5326624280
#yiv5326624280ygrp-mlmsg pre, #yiv5326624280 code {font:115%
monospace;}#yiv5326624280 #yiv5326624280ygrp-mlmsg *
{line-height:1.22em;}#yiv5326624280 #yiv5326624280ygrp-mlmsg #yiv5326624280logo
{padding-bottom:10px;}#yiv5326624280 #yiv5326624280ygrp-msg p a
{font-family:Verdana;}#yiv5326624280 #yiv5326624280ygrp-msg
p#yiv5326624280attach-count span {color:#1E66AE;font-weight:700;}#yiv5326624280
#yiv5326624280ygrp-reco #yiv5326624280reco-head
{color:#ff7900;font-weight:700;}#yiv5326624280 #yiv5326624280ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv5326624280 #yiv5326624280ygrp-sponsor
#yiv5326624280ov li a {font-size:130%;text-decoration:none;}#yiv5326624280
#yiv5326624280ygrp-sponsor #yiv5326624280ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv5326624280
#yiv5326624280ygrp-sponsor #yiv5326624280ov ul {margin:0;padding:0 0 0
8px;}#yiv5326624280 #yiv5326624280ygrp-text
{font-family:Georgia;}#yiv5326624280 #yiv5326624280ygrp-text p {margin:0 0 1em
0;}#yiv5326624280 #yiv5326624280ygrp-text tt {font-size:120%;}#yiv5326624280
#yiv5326624280ygrp-vital ul li:last-child {border-right:none
!important;}#yiv5326624280
