itu bisa kok, insert table pada masing2 sheet yang ada, untuk menghindari salah input nama barang bisa di buatkan list validation yang di ambil dari sheet stok, untuk lebih jelasnya bisa liat lampiran berikut. br,
odong nando
Dari: "Dody Irawan dodyirawa...@gmail.com [belajar-excel]"
<belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Kamis, 4 Februari 2016 14:49
Judul: [belajar-excel] [belajar excel] mohon bantuan untuk membuat stok
sederhana [1 Attachment]
Mohon bantuannya temen-temen master.
gimana caranya buat stok yang otomatis ter update.
file terlampir.
maaf pemula banget..... #yiv4867285830 #yiv4867285830 --
#yiv4867285830ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}#yiv4867285830 #yiv4867285830ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv4867285830 #yiv4867285830ygrp-mkp #yiv4867285830hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4867285830 #yiv4867285830ygrp-mkp #yiv4867285830ads
{margin-bottom:10px;}#yiv4867285830 #yiv4867285830ygrp-mkp .yiv4867285830ad
{padding:0 0;}#yiv4867285830 #yiv4867285830ygrp-mkp .yiv4867285830ad p
{margin:0;}#yiv4867285830 #yiv4867285830ygrp-mkp .yiv4867285830ad a
{color:#0000ff;text-decoration:none;}#yiv4867285830 #yiv4867285830ygrp-sponsor
#yiv4867285830ygrp-lc {font-family:Arial;}#yiv4867285830
#yiv4867285830ygrp-sponsor #yiv4867285830ygrp-lc #yiv4867285830hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4867285830
#yiv4867285830ygrp-sponsor #yiv4867285830ygrp-lc .yiv4867285830ad
{margin-bottom:10px;padding:0 0;}#yiv4867285830 #yiv4867285830actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4867285830
#yiv4867285830activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4867285830
#yiv4867285830activity span {font-weight:700;}#yiv4867285830
#yiv4867285830activity span:first-child
{text-transform:uppercase;}#yiv4867285830 #yiv4867285830activity span a
{color:#5085b6;text-decoration:none;}#yiv4867285830 #yiv4867285830activity span
span {color:#ff7900;}#yiv4867285830 #yiv4867285830activity span
.yiv4867285830underline {text-decoration:underline;}#yiv4867285830
.yiv4867285830attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4867285830 .yiv4867285830attach div a
{text-decoration:none;}#yiv4867285830 .yiv4867285830attach img
{border:none;padding-right:5px;}#yiv4867285830 .yiv4867285830attach label
{display:block;margin-bottom:5px;}#yiv4867285830 .yiv4867285830attach label a
{text-decoration:none;}#yiv4867285830 blockquote {margin:0 0 0
4px;}#yiv4867285830 .yiv4867285830bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4867285830
.yiv4867285830bold a {text-decoration:none;}#yiv4867285830 dd.yiv4867285830last
p a {font-family:Verdana;font-weight:700;}#yiv4867285830 dd.yiv4867285830last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4867285830
dd.yiv4867285830last p span.yiv4867285830yshortcuts
{margin-right:0;}#yiv4867285830 div.yiv4867285830attach-table div div a
{text-decoration:none;}#yiv4867285830 div.yiv4867285830attach-table
{width:400px;}#yiv4867285830 div.yiv4867285830file-title a, #yiv4867285830
div.yiv4867285830file-title a:active, #yiv4867285830
div.yiv4867285830file-title a:hover, #yiv4867285830 div.yiv4867285830file-title
a:visited {text-decoration:none;}#yiv4867285830 div.yiv4867285830photo-title a,
#yiv4867285830 div.yiv4867285830photo-title a:active, #yiv4867285830
div.yiv4867285830photo-title a:hover, #yiv4867285830
div.yiv4867285830photo-title a:visited {text-decoration:none;}#yiv4867285830
div#yiv4867285830ygrp-mlmsg #yiv4867285830ygrp-msg p a
span.yiv4867285830yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4867285830
.yiv4867285830green {color:#628c2a;}#yiv4867285830 .yiv4867285830MsoNormal
{margin:0 0 0 0;}#yiv4867285830 o {font-size:0;}#yiv4867285830
#yiv4867285830photos div {float:left;width:72px;}#yiv4867285830
#yiv4867285830photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv4867285830
#yiv4867285830photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4867285830
#yiv4867285830reco-category {font-size:77%;}#yiv4867285830
#yiv4867285830reco-desc {font-size:77%;}#yiv4867285830 .yiv4867285830replbq
{margin:4px;}#yiv4867285830 #yiv4867285830ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4867285830 #yiv4867285830ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4867285830
#yiv4867285830ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4867285830
#yiv4867285830ygrp-mlmsg select, #yiv4867285830 input, #yiv4867285830 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4867285830
#yiv4867285830ygrp-mlmsg pre, #yiv4867285830 code {font:115%
monospace;}#yiv4867285830 #yiv4867285830ygrp-mlmsg *
{line-height:1.22em;}#yiv4867285830 #yiv4867285830ygrp-mlmsg #yiv4867285830logo
{padding-bottom:10px;}#yiv4867285830 #yiv4867285830ygrp-msg p a
{font-family:Verdana;}#yiv4867285830 #yiv4867285830ygrp-msg
p#yiv4867285830attach-count span {color:#1E66AE;font-weight:700;}#yiv4867285830
#yiv4867285830ygrp-reco #yiv4867285830reco-head
{color:#ff7900;font-weight:700;}#yiv4867285830 #yiv4867285830ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4867285830 #yiv4867285830ygrp-sponsor
#yiv4867285830ov li a {font-size:130%;text-decoration:none;}#yiv4867285830
#yiv4867285830ygrp-sponsor #yiv4867285830ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4867285830
#yiv4867285830ygrp-sponsor #yiv4867285830ov ul {margin:0;padding:0 0 0
8px;}#yiv4867285830 #yiv4867285830ygrp-text
{font-family:Georgia;}#yiv4867285830 #yiv4867285830ygrp-text p {margin:0 0 1em
0;}#yiv4867285830 #yiv4867285830ygrp-text tt {font-size:120%;}#yiv4867285830
#yiv4867285830ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4867285830
stok_od.xlsx
Description: MS-Excel 2007 spreadsheet
