ini ada 2 file yg saya ketik manual hanya ada perumusan umum saja ,, invoice dan surat jalan berbeda file nya .. mohon informasi selanjutnya.. terimakasih
Pada Rabu, 11 Maret 2015 16:07, "hendrik karnadi [email protected]
[belajar-excel]" <[email protected]> menulis:
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
#yiv8675970387 #yiv8675970387 -- #yiv8675970387ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8675970387
#yiv8675970387ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8675970387
#yiv8675970387ygrp-mkp #yiv8675970387hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8675970387 #yiv8675970387ygrp-mkp #yiv8675970387ads
{margin-bottom:10px;}#yiv8675970387 #yiv8675970387ygrp-mkp .yiv8675970387ad
{padding:0 0;}#yiv8675970387 #yiv8675970387ygrp-mkp .yiv8675970387ad p
{margin:0;}#yiv8675970387 #yiv8675970387ygrp-mkp .yiv8675970387ad a
{color:#0000ff;text-decoration:none;}#yiv8675970387 #yiv8675970387ygrp-sponsor
#yiv8675970387ygrp-lc {font-family:Arial;}#yiv8675970387
#yiv8675970387ygrp-sponsor #yiv8675970387ygrp-lc #yiv8675970387hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8675970387
#yiv8675970387ygrp-sponsor #yiv8675970387ygrp-lc .yiv8675970387ad
{margin-bottom:10px;padding:0 0;}#yiv8675970387 #yiv8675970387actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8675970387
#yiv8675970387activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8675970387
#yiv8675970387activity span {font-weight:700;}#yiv8675970387
#yiv8675970387activity span:first-child
{text-transform:uppercase;}#yiv8675970387 #yiv8675970387activity span a
{color:#5085b6;text-decoration:none;}#yiv8675970387 #yiv8675970387activity span
span {color:#ff7900;}#yiv8675970387 #yiv8675970387activity span
.yiv8675970387underline {text-decoration:underline;}#yiv8675970387
.yiv8675970387attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv8675970387 .yiv8675970387attach div a
{text-decoration:none;}#yiv8675970387 .yiv8675970387attach img
{border:none;padding-right:5px;}#yiv8675970387 .yiv8675970387attach label
{display:block;margin-bottom:5px;}#yiv8675970387 .yiv8675970387attach label a
{text-decoration:none;}#yiv8675970387 blockquote {margin:0 0 0
4px;}#yiv8675970387 .yiv8675970387bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8675970387
.yiv8675970387bold a {text-decoration:none;}#yiv8675970387 dd.yiv8675970387last
p a {font-family:Verdana;font-weight:700;}#yiv8675970387 dd.yiv8675970387last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8675970387
dd.yiv8675970387last p span.yiv8675970387yshortcuts
{margin-right:0;}#yiv8675970387 div.yiv8675970387attach-table div div a
{text-decoration:none;}#yiv8675970387 div.yiv8675970387attach-table
{width:400px;}#yiv8675970387 div.yiv8675970387file-title a, #yiv8675970387
div.yiv8675970387file-title a:active, #yiv8675970387
div.yiv8675970387file-title a:hover, #yiv8675970387 div.yiv8675970387file-title
a:visited {text-decoration:none;}#yiv8675970387 div.yiv8675970387photo-title a,
#yiv8675970387 div.yiv8675970387photo-title a:active, #yiv8675970387
div.yiv8675970387photo-title a:hover, #yiv8675970387
div.yiv8675970387photo-title a:visited {text-decoration:none;}#yiv8675970387
div#yiv8675970387ygrp-mlmsg #yiv8675970387ygrp-msg p a
span.yiv8675970387yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8675970387
.yiv8675970387green {color:#628c2a;}#yiv8675970387 .yiv8675970387MsoNormal
{margin:0 0 0 0;}#yiv8675970387 o {font-size:0;}#yiv8675970387
#yiv8675970387photos div {float:left;width:72px;}#yiv8675970387
#yiv8675970387photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv8675970387
#yiv8675970387photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8675970387
#yiv8675970387reco-category {font-size:77%;}#yiv8675970387
#yiv8675970387reco-desc {font-size:77%;}#yiv8675970387 .yiv8675970387replbq
{margin:4px;}#yiv8675970387 #yiv8675970387ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv8675970387 #yiv8675970387ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8675970387
#yiv8675970387ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8675970387
#yiv8675970387ygrp-mlmsg select, #yiv8675970387 input, #yiv8675970387 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8675970387
#yiv8675970387ygrp-mlmsg pre, #yiv8675970387 code {font:115%
monospace;}#yiv8675970387 #yiv8675970387ygrp-mlmsg *
{line-height:1.22em;}#yiv8675970387 #yiv8675970387ygrp-mlmsg #yiv8675970387logo
{padding-bottom:10px;}#yiv8675970387 #yiv8675970387ygrp-msg p a
{font-family:Verdana;}#yiv8675970387 #yiv8675970387ygrp-msg
p#yiv8675970387attach-count span {color:#1E66AE;font-weight:700;}#yiv8675970387
#yiv8675970387ygrp-reco #yiv8675970387reco-head
{color:#ff7900;font-weight:700;}#yiv8675970387 #yiv8675970387ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv8675970387 #yiv8675970387ygrp-sponsor
#yiv8675970387ov li a {font-size:130%;text-decoration:none;}#yiv8675970387
#yiv8675970387ygrp-sponsor #yiv8675970387ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8675970387
#yiv8675970387ygrp-sponsor #yiv8675970387ov ul {margin:0;padding:0 0 0
8px;}#yiv8675970387 #yiv8675970387ygrp-text
{font-family:Georgia;}#yiv8675970387 #yiv8675970387ygrp-text p {margin:0 0 1em
0;}#yiv8675970387 #yiv8675970387ygrp-text tt {font-size:120%;}#yiv8675970387
#yiv8675970387ygrp-vital ul li:last-child {border-right:none
!important;}#yiv8675970387
Report Invoice.xlsx
Description: MS-Excel 2007 spreadsheet
Data Surat Jalan.xlsx
Description: MS-Excel 2007 spreadsheet
