营业收入台帐格式，兄弟们来看！

我菜故我在 · 发表于 2006-10-23 16:49

这是格式　我想做一个电子表格　功能要求能自动计算　有下拉　（我有500-600个客户要输入）累啊！高手帮我设计一下　我自己也会上传新的我自己弄的表格　不过很差劲的　大家不要笑！

8sQMGBmE.rar (4.19 KB, 下载次数: 142) 就是表格目录批注中的问题和营业收入销售台帐中结存金额的公式这样输对吗　好像不太好看　所有格中都有14000了　有更发孤方法吗　　赐教啊！

[此贴子已经被作者于2006-10-28 10:36:45编辑过]

gzh272727 · 发表于 2006-10-23 16:59

不明白为什么要这样做,如果有五六百个客户,应该是很大的公司啊,公司可以上软件啊

我菜故我在 · 发表于 2006-10-24 14:15

台帐是帐外的这种软件很少有吧？

gstscmh · 发表于 2006-10-24 14:52

简单,QQ:495651568,tel:0938-3629988

我菜故我在 · 发表于 2006-10-24 15:40

你的是收费的吗？

我菜故我在 · 发表于 2006-10-27 15:49

简单个屁　那有硬逼我买的啊　还没得试用　

yvhf · 发表于 2006-10-29 20:23

<table cellspacing="0" cellpadding="0" width="627" border="0" style="WIDTH: 469pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="2" width="19" style="WIDTH: 14pt; mso-width-source: userset; mso-width-alt: 608;"></col><col width="34" style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1088;"></col><col width="23" style="WIDTH: 17pt; mso-width-source: userset; mso-width-alt: 736;"></col><col width="41" style="WIDTH: 31pt; mso-width-source: userset; mso-width-alt: 1312;"></col><col width="47" style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1504;"></col><col width="23" style="WIDTH: 17pt; mso-width-source: userset; mso-width-alt: 736;"></col><col width="41" style="WIDTH: 31pt; mso-width-source: userset; mso-width-alt: 1312;"></col><col width="47" style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1504;"></col><col width="23" style="WIDTH: 17pt; mso-width-source: userset; mso-width-alt: 736;"></col><col width="41" style="WIDTH: 31pt; mso-width-source: userset; mso-width-alt: 1312;"></col><col width="47" style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1504;"></col><col width="23" style="WIDTH: 17pt; mso-width-source: userset; mso-width-alt: 736;"></col><col width="41" style="WIDTH: 31pt; mso-width-source: userset; mso-width-alt: 1312;"></col><col width="47" style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1504;"></col><col width="23" style="WIDTH: 17pt; mso-width-source: userset; mso-width-alt: 736;"></col><col width="41" style="WIDTH: 31pt; mso-width-source: userset; mso-width-alt: 1312;"></col><col width="47" style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1504;"></col></colgroup><tbody><tr height="27" style="HEIGHT: 20.25pt; mso-height-source: userset;"><td class="xl31" width="38" colspan="2" height="27" style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 28pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent;">年</td><td class="xl33" width="34" rowspan="2" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 26pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent;">发货单号码</td><td class="xl28" width="111" colspan="3" style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 83pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">1</td><td class="xl28" width="111" colspan="3" style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 83pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">2</td><td class="xl28" width="111" colspan="3" style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 83pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">3</td><td class="xl28" width="111" colspan="3" style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 83pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">4</td><td class="xl28" width="111" colspan="3" style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 83pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">5</td></tr><tr height="42" style="HEIGHT: 31.5pt; mso-height-source: userset;"><td class="xl24" height="42" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 31.5pt; BACKGROUND-COLOR: transparent;">月</td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">日</td><td class="xl26" width="23" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 17pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">数量</td><td class="xl26" width="41" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 31pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">单　　价</td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">金额</td><td class="xl26" width="23" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 17pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">数量</td><td class="xl26" width="41" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 31pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">单　　价</td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">金额</td><td class="xl26" width="23" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 17pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">数量</td><td class="xl26" width="41" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 31pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">单　　价</td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">金额</td><td class="xl26" width="23" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 17pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">数量</td><td class="xl26" width="41" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 31pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">单　　价</td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">金额</td><td class="xl26" width="23" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 17pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">数量</td><td class="xl26" width="41" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 31pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">单　　价</td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">金额</td></tr><tr height="35" style="HEIGHT: 26.25pt; mso-height-source: userset;"><td class="xl25" align="right" height="35" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt; BACKGROUND-COLOR: transparent;">12</td><td class="xl25" align="right" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">31</td><td class="xl25" align="right" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">2343</td><td class="xl25" align="right" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">2</td><td class="xl25" align="right" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">7000</td><td class="xl25" align="right" xfmla="=D3*E3" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">14000</td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl25" xfmla="=G3*H3" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl25" xfmla="=J3*K3" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl25" xfmla="=M3*N3" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl25" xfmla="=P3*Q3" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td></tr></tbody></table>这些1、２、３、４、５是什么？每次发货的记录？建议，所有客户的销售记录放在同一个表格中，看客户的交往情况，就用其他手段，读取到一定的地方？－－－－－不是本行，妄语了

我菜故我在 · 发表于 2006-10-30 12:55

<div class="msgheader">QUOTE:</div><div class="msgborder">以下是引用yvhf在2006-10-29 20:23:20的发言： <table cellspacing="0" cellpadding="0" width="627" border="0" style="WIDTH: 469pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="2" width="19" style="WIDTH: 14pt; mso-width-source: userset; mso-width-alt: 608;"></col><col></col><col width="34" style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1088;"></col><col></col><col width="23" style="WIDTH: 17pt; mso-width-source: userset; mso-width-alt: 736;"></col><col></col><col width="41" style="WIDTH: 31pt; mso-width-source: userset; mso-width-alt: 1312;"></col><col></col><col width="47" style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1504;"></col><col></col><col width="23" style="WIDTH: 17pt; mso-width-source: userset; mso-width-alt: 736;"></col><col></col><col width="41" style="WIDTH: 31pt; mso-width-source: userset; mso-width-alt: 1312;"></col><col></col><col width="47" style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1504;"></col><col></col><col width="23" style="WIDTH: 17pt; mso-width-source: userset; mso-width-alt: 736;"></col><col></col><col width="41" style="WIDTH: 31pt; mso-width-source: userset; mso-width-alt: 1312;"></col><col></col><col width="47" style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1504;"></col><col></col><col width="23" style="WIDTH: 17pt; mso-width-source: userset; mso-width-alt: 736;"></col><col></col><col width="41" style="WIDTH: 31pt; mso-width-source: userset; mso-width-alt: 1312;"></col><col></col><col width="47" style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1504;"></col><col></col><col width="23" style="WIDTH: 17pt; mso-width-source: userset; mso-width-alt: 736;"></col><col></col><col width="41" style="WIDTH: 31pt; mso-width-source: userset; mso-width-alt: 1312;"></col><col></col><col width="47" style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1504;"></col><col></col></colgroup><tbody><tr height="27" style="HEIGHT: 20.25pt; mso-height-source: userset;"><td class="xl31" width="38" colspan="2" height="27" style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 28pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 20.25pt; BACKGROUND-COLOR: transparent;">年</td><td class="xl33" width="34" rowspan="2" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 26pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent;">发货单号码</td><td class="xl28" width="111" colspan="3" style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 83pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">1</td><td class="xl28" width="111" colspan="3" style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 83pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">2</td><td class="xl28" width="111" colspan="3" style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 83pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">3</td><td class="xl28" width="111" colspan="3" style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 83pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">4</td><td class="xl28" width="111" colspan="3" style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 83pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">5</td></tr><tr height="42" style="HEIGHT: 31.5pt; mso-height-source: userset;"><td class="xl24" height="42" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 31.5pt; BACKGROUND-COLOR: transparent;">月</td><td class="xl24" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">日</td><td class="xl26" width="23" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 17pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">数量</td><td class="xl26" width="41" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 31pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">单　　价</td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">金额</td><td class="xl26" width="23" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 17pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">数量</td><td class="xl26" width="41" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 31pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">单　　价</td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">金额</td><td class="xl26" width="23" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 17pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">数量</td><td class="xl26" width="41" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 31pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">单　　价</td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">金额</td><td class="xl26" width="23" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 17pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">数量</td><td class="xl26" width="41" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 31pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">单　　价</td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">金额</td><td class="xl26" width="23" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 17pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">数量</td><td class="xl26" width="41" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 31pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">单　　价</td><td class="xl27" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">金额</td></tr><tr height="35" style="HEIGHT: 26.25pt; mso-height-source: userset;"><td class="xl25" align="right" height="35" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt; BACKGROUND-COLOR: transparent;">12</td><td class="xl25" align="right" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">31</td><td class="xl25" align="right" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">2343</td><td class="xl25" align="right" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">2</td><td class="xl25" align="right" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">7000</td><td class="xl25" align="right" xfmla="=D3*E3" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">14000</td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl25" xfmla="=G3*H3" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl25" xfmla="=J3*K3" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl25" xfmla="=M3*N3" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl25" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl25" xfmla="=P3*Q3" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td></tr></tbody></table>这些1、２、３、４、５是什么？每次发货的记录？建议，所有客户的销售记录放在同一个表格中，看客户的交往情况，就用其他手段，读取到一定的地方？－－－－－不是本行，妄语了</div>12345是指我们公司的产品型号我没写清就用这个来代了放在一起然后怎么读取呢　要通过什么来实现啊　我弄不来的啊　超琏接不行啊

yvhf · 发表于 2006-10-30 15:09

<div class="msgheader">QUOTE:</div><div class="msgborder">以下是引用我菜故我在在2006-10-30 12:55:35的发言： 12345是指我们公司的产品型号我没写清就用这个来代了放在一起然后怎么读取呢　要通过什么来实现啊　我弄不来的啊　超琏接不行啊</div>简单做了一个

TCGmBSxS.rar (11.53 KB, 下载次数: 118)

我菜故我在 · 发表于 2006-10-30 16:35

谢谢了　下载下来研究一下！

		自动登录	找回密码
密码			免费注册

[求助] 营业收入台帐格式，兄弟们来看！