明细账表格,请各位高手改进

抱梅觅雪 · 发表于 2005-7-30 22:03

太麻烦了。原始数据还得要逐笔分类登记？

lijia_3000 · 发表于 2005-8-4 15:42

已经不错了，做的简单易懂

zyh520 · 发表于 2005-8-29 21:54

做得好好哦，呜呜，我是菜鸟，都不知道什么时候才有这个水平？

carrefour · 发表于 2007-5-7 10:23

这是什么格式的啊？我怎么打开以后都是乱码？是Ｅｘｅｌ的吗？

zxh6613615 · 发表于 2007-5-8 10:47

好[em22][em22][em17][em17]

cathybao · 发表于 2007-5-8 22:41

不错，我先下了，好好研究一下。

applebear · 发表于 2007-5-9 11:09

做的还不错啊,值的学习

weichong · 发表于 2007-5-9 11:32

这样设不好,如果3000个明细帐户岂不是要3000个表,应把EXCEL按数据库的格式设置,3个表就好,一个上期余额,一个本期发生额,一个查询界面,按数据库格式录入上期余额及本期发生额,用VBA语句设置对话框,输入名称查询上期余额及本期发生额复制到界面上并执行余额计算.

hwhxhcw · 发表于 2007-5-9 13:12

不错

zaq03 · 发表于 2007-5-10 10:33

斑竹制作的版面比较美观，大方。建议：在每张表格上面单独制作汇总各月的的小计表,因为业务发生频繁,每次都要改后面的公式.<table cellspacing="0" cellpadding="0" width="672" border="0" style="WIDTH: 505pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="2" width="28" style="WIDTH: 21pt; mso-width-source: userset; mso-width-alt: 896;"></col><col width="29" style="WIDTH: 22pt; mso-width-source: userset; mso-width-alt: 928;"></col><col width="147" style="WIDTH: 110pt; mso-width-source: userset; mso-width-alt: 4704;"></col><col width="70" style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2240;"></col><col span="2" width="117" style="WIDTH: 88pt; mso-width-source: userset; mso-width-alt: 3744;"></col><col width="19" style="WIDTH: 14pt; mso-width-source: userset; mso-width-alt: 608;"></col><col width="117" style="WIDTH: 88pt; mso-width-source: userset; mso-width-alt: 3744;"></col></colgroup><tbody><tr height="20" style="HEIGHT: 15pt;"><td class="xl54" width="56" colspan="2" height="20" style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: red 2pt double; BORDER-LEFT: red 2pt double; WIDTH: 42pt; BORDER-BOTTOM: black 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent;">　</td><td class="xl55" width="29" rowspan="2" style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: red 2pt double; BORDER-LEFT: black 0.5pt solid; WIDTH: 22pt; BORDER-BOTTOM: red 2pt double; BACKGROUND-COLOR: transparent;">凭证</td><td class="xl46" width="147" rowspan="2" style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: red 2pt double; BORDER-LEFT: black 0.5pt solid; WIDTH: 110pt; BORDER-BOTTOM: red 2pt double; BACKGROUND-COLOR: transparent;">摘要</td><td class="xl48" width="70" rowspan="2" style="BORDER-RIGHT: red 2pt double; BORDER-TOP: red 2pt double; BORDER-LEFT: black 0.5pt solid; WIDTH: 53pt; BORDER-BOTTOM: red 2pt double; BACKGROUND-COLOR: transparent;">支票号码</td><td class="xl50" width="117" rowspan="2" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: red 2pt double; BORDER-LEFT: #d4d0c8; WIDTH: 88pt; BORDER-BOTTOM: red 2pt double; BACKGROUND-COLOR: transparent;"> 借方 </td><td class="xl52" width="117" rowspan="2" style="BORDER-RIGHT: red 2pt double; BORDER-TOP: red 2pt double; BORDER-LEFT: red 2pt double; WIDTH: 88pt; BORDER-BOTTOM: red 2pt double; BACKGROUND-COLOR: transparent;"> 贷方 </td><td class="xl44" width="19" rowspan="2" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: red 2pt double; BORDER-LEFT: #d4d0c8; WIDTH: 14pt; BORDER-BOTTOM: red 2pt double; BACKGROUND-COLOR: transparent;">对账</td><td class="xl52" width="117" rowspan="2" style="BORDER-RIGHT: red 2pt double; BORDER-TOP: red 2pt double; BORDER-LEFT: red 2pt double; WIDTH: 88pt; BORDER-BOTTOM: red 2pt double; BACKGROUND-COLOR: transparent;"> 余额 </td></tr><tr height="29" style="HEIGHT: 21.75pt; mso-height-source: userset;"><td class="xl25" height="29" style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: red 2pt double; BORDER-BOTTOM: red 2pt double; HEIGHT: 21.75pt; BACKGROUND-COLOR: transparent;">月</td><td class="xl26" style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; BORDER-BOTTOM: red 2pt double; BACKGROUND-COLOR: transparent;">日</td></tr><tr height="20" style="HEIGHT: 15pt;"><td class="xl27" height="20" style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: red; BORDER-LEFT: red 2pt double; BORDER-BOTTOM: black 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent;">　</td><td class="xl28" style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: red; BORDER-LEFT: black; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl29" style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: red; BORDER-LEFT: black; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl32" style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: red; BORDER-LEFT: black; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent;">期初数</td><td class="xl30" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: red; BORDER-LEFT: black; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl33" style="BORDER-RIGHT: red 2pt double; BORDER-TOP: red; BORDER-LEFT: red 2pt double; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl34" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: red; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl31" style="BORDER-RIGHT: red 2pt double; BORDER-TOP: red; BORDER-LEFT: red 2pt double; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl41" style="BORDER-RIGHT: red 2pt double; BORDER-TOP: red; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent;">　200</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl36" height="19" style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: red 2pt double; BORDER-BOTTOM: black 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">　1</td><td class="xl37" style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent;">1　</td><td class="xl38" style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl37" style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl39" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: black; BORDER-LEFT: black; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl42" style="BORDER-RIGHT: red 2pt double; BORDER-TOP: black; BORDER-LEFT: red 2pt double; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent;">　100</td><td class="xl43" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: black; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl40" style="BORDER-RIGHT: red 2pt double; BORDER-TOP: black; BORDER-LEFT: red 2pt double; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl35" style="BORDER-RIGHT: red 2pt double; BORDER-TOP: black; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: transparent;"> -   300</td></tr></tbody></table>用sumif公式汇总一月的小计  月   借方小计                            贷方小计                    余额     1    SUMIF(A7:A1000,1,F7:F1000)=100  SUMIF(A7:A1000,1,G7:G1000)=0   = I7+借方小计-贷方小计   其他月份同理                                                        =I7 变为1月计算的结果这样，增减行公式有问题，你也能检查平衡关系。我先写道这里，这样为以后汇总提供连接作准备。呵呵，请大家指正！

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

[原创] 明细账表格,请各位高手改进