我想提取上个月的余额

瑾果

我本月的收入是用宏做出来的，然后余额里一个公式显示。


可是我上月的余额怎么做呢？



<TABLE style="WIDTH: 330pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=439 border=0 x:str>
<COLGROUP>
<COL style="WIDTH: 100pt; mso-width-source: userset; mso-width-alt: 4256" width=133>
<COL style="WIDTH: 109pt; mso-width-source: userset; mso-width-alt: 4640" width=145>
<COL style="WIDTH: 121pt; mso-width-source: userset; mso-width-alt: 5152" width=161>
<TBODY>
<TR style="HEIGHT: 23.1pt; mso-height-source: userset" height=30>
<TD class=xl26 style="BORDER-RIGHT: #c0c0c0 0.5pt; BORDER-TOP: #c0c0c0 0.5pt; BORDER-LEFT: #c0c0c0 0.5pt; WIDTH: 100pt; BORDER-BOTTOM: #c0c0c0 0.5pt; HEIGHT: 23.1pt; BACKGROUND-COLOR: transparent" width=133 height=30 x:str="本月收入"><FONT face=宋体><SPAN style="mso-spacerun: yes">        </SPAN>本月收入 </FONT></TD>
<TD class=xl26 style="BORDER-RIGHT: #c0c0c0 0.5pt; BORDER-TOP: #c0c0c0 0.5pt; BORDER-LEFT: #c0c0c0; WIDTH: 109pt; BORDER-BOTTOM: #c0c0c0 0.5pt; BACKGROUND-COLOR: transparent" width=145 x:str="本月支出"><FONT face=宋体><SPAN style="mso-spacerun: yes">        </SPAN>本月支出 </FONT></TD>
<TD class=xl26 style="BORDER-RIGHT: #c0c0c0 0.5pt; BORDER-TOP: #c0c0c0 0.5pt; BORDER-LEFT: #c0c0c0; WIDTH: 121pt; BORDER-BOTTOM: #c0c0c0 0.5pt; BACKGROUND-COLOR: transparent" width=161 x:str="余额"><FONT face=宋体><SPAN style="mso-spacerun: yes">        </SPAN>余额 </FONT></TD></TR>
<TR style="HEIGHT: 23.1pt; mso-height-source: userset" height=30>
<TD class=xl24 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0 0.5pt; FONT-WEIGHT: 700; BACKGROUND: #ffff99; BORDER-LEFT: #c0c0c0 0.5pt; BORDER-BOTTOM: #c0c0c0 0.5pt; HEIGHT: 23.1pt; mso-ignore: style; mso-pattern: auto none" height=30 x:num="1012"><FONT face=宋体>1012.00 </FONT></TD>
<TD class=xl25 style="BORDER-RIGHT: #c0c0c0 0.5pt; BORDER-TOP: #c0c0c0; FONT-WEIGHT: 700; BACKGROUND: #ffff99; BORDER-LEFT: #c0c0c0 0.5pt; BORDER-BOTTOM: #c0c0c0 0.5pt; mso-ignore: style; mso-pattern: auto none"><FONT face=宋体>‘=支出!$G$4</FONT></TD>
<TD class=xl27 style="BORDER-RIGHT: #c0c0c0 0.5pt; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0 0.5pt; BACKGROUND-COLOR: transparent" align=middle x:err="#VALUE!"><FONT face=宋体>#VALUE!</FONT></TD></TR>
<TR style="HEIGHT: 23.1pt; mso-height-source: userset" height=30>
<TD class=xl24 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0 0.5pt; BORDER-BOTTOM: #c0c0c0 0.5pt; HEIGHT: 23.1pt; BACKGROUND-COLOR: transparent" height=30 x:num="0"><FONT face=宋体>　</FONT></TD>
<TD class=xl25 style="BORDER-RIGHT: #c0c0c0 0.5pt; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0 0.5pt; BORDER-BOTTOM: #c0c0c0 0.5pt; BACKGROUND-COLOR: transparent" x:num="0"><FONT face=宋体>　</FONT></TD>
<TD class=xl27 style="BORDER-RIGHT: #c0c0c0 0.5pt; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0 0.5pt; BACKGROUND-COLOR: transparent" x:num="0"><FONT face=宋体>　</FONT></TD></TR>
<TR style="HEIGHT: 23.1pt; mso-height-source: userset" height=30>
<TD class=xl24 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0 0.5pt; BORDER-BOTTOM: #c0c0c0 0.5pt; HEIGHT: 23.1pt; BACKGROUND-COLOR: transparent" height=30 x:num="0"><FONT face=宋体>　</FONT></TD>
<TD class=xl25 style="BORDER-RIGHT: #c0c0c0 0.5pt; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0 0.5pt; BORDER-BOTTOM: #c0c0c0 0.5pt; BACKGROUND-COLOR: transparent" x:num="0"><FONT face=宋体>　</FONT></TD>
<TD class=xl27 style="BORDER-RIGHT: #c0c0c0 0.5pt; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0 0.5pt; BACKGROUND-COLOR: transparent" x:num="0"><FONT face=宋体>　</FONT></TD></TR>
<TR style="HEIGHT: 23.1pt; mso-height-source: userset" height=30>
<TD class=xl24 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0 0.5pt; BORDER-BOTTOM: #c0c0c0 0.5pt; HEIGHT: 23.1pt; BACKGROUND-COLOR: transparent" height=30 x:num="0"><FONT face=宋体>　</FONT></TD>
<TD class=xl25 style="BORDER-RIGHT: #c0c0c0 0.5pt; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0 0.5pt; BORDER-BOTTOM: #c0c0c0 0.5pt; BACKGROUND-COLOR: transparent" x:num="0"><FONT face=宋体>　</FONT></TD>
<TD class=xl27 style="BORDER-RIGHT: #c0c0c0 0.5pt; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0; BORDER-BOTTOM: #c0c0c0 0.5pt; BACKGROUND-COLOR: transparent" x:num="0"><FONT face=宋体>　</FONT></TD></TR>
<TR style="HEIGHT: 23.1pt; mso-height-source: userset" height=30>
<TD class=xl24 style="BORDER-RIGHT: #c0c0c0; BORDER-TOP: #c0c0c0 0.5pt; FONT-WEIGHT: 700; BACKGROUND: #ffff99; BORDER-LEFT: #c0c0c0 0.5pt; BORDER-BOTTOM: #c0c0c0 0.5pt; HEIGHT: 23.1pt; mso-ignore: style; mso-pattern: auto none" height=30 x:num="190000"><FONT face=宋体>190000.00 </FONT></TD>
<TD class=xl25 style="BORDER-RIGHT: #c0c0c0 0.5pt; BORDER-TOP: #c0c0c0; BORDER-LEFT: #c0c0c0 0.5pt; BORDER-BOTTOM: #c0c0c0 0.5pt; BACKGROUND-COLOR: transparent" x:num="0"><FONT face=宋体>　</FONT></TD>
<TD class=xl27 style="BORDER-RIGHT: #c0c0c0 0.5pt; BORDER-TOP: #c0c0c0; FONT-WEIGHT: 700; BACKGROUND: #ffff99; BORDER-LEFT: #c0c0c0 0.5pt; BORDER-BOTTOM: #c0c0c0 0.5pt; mso-ignore: style; mso-pattern: auto none" align=right x:num="190000"><FONT face=宋体>190000.00 </FONT></TD></TR></TBODY></TABLE>

hzg7818

<A href="http://club.excelhome.net/viewthread.php?tid=38396" target="_blank" >http://club.excelhome.net/viewthread.php?tid=38396</A>


参考这个例子看看是否适合？

瑾果

呵呵，谢谢，我先去看看。

瑾果

可是，我的余额并没有以数字形式表现出来。怎么引用呢？