Check book register template

JM Hazel · External Since: Nov 09, 2005 Posts: 1

I just started using the Checkbook register template and love it. Until I
need to add some more rows, now the addition and subtraction feature in the
Balance column doesn't work.
What did I do wrong?
How can I continue to put information in added rows and continue to get the
Balance feature to work.
Thanks for your help
--
JM Hazel

Teacher_Becky · External Since: Nov 17, 2005 Posts: 4

I'm having the same difficulty of finding a way to extend/lengthen my balance
template. The Ctrl+D works great - I didn't know that - very handy. But it
seems to only work for existing cells. I need more than the 12 rows allotted
in this template. There doesn't seem to be any "insert rows" available. I'm
using Excel 2002. What are we missing?
Thanks for any more help on this.
Becky

"Gary''s Student" wrote:

> When you insert a new, empty, row into a checkbook, you are usually
> introducing a blank cell into a column containing formulae. You need to
> continue the formulae through the blanks.
>
> 1. find a blank cell with a formula above
> 2. select the cell and touch CNTRL-D this will copy the formula from the
> cell above
> 3. select the cell below the new (previously blank) cell and touch CNTRL-D
> again
> --
> Gary's Student
>
>
> "JM Hazel" wrote:
>
> > I just started using the Checkbook register template and love it. Until I
> > need to add some more rows, now the addition and subtraction feature in the
> > Balance column doesn't work.
> > What did I do wrong?
> > How can I continue to put information in added rows and continue to get the
> > Balance feature to work.
> > Thanks for your help
> > --
> > JM Hazel

Joyce · External Since: Jan 27, 2005 Posts: 34

I like the Checkbook register template for basic use, too. Does anyone know
how to add a formula to the column named "C" so that cleared checks can be
checked off and my checkbook can be balanced automatically?
--
J.

"JM Hazel" wrote:

> I just started using the Checkbook register template and love it. Until I
> need to add some more rows, now the addition and subtraction feature in the
> Balance column doesn't work.
> What did I do wrong?
> How can I continue to put information in added rows and continue to get the
> Balance feature to work.
> Thanks for your help
> --
> JM Hazel

Roger Govier · External Since: Feb 09, 2005 Posts: 2965

Hi Joyce

One way would be to add a column I called Cleared balance.
Click on the column header for column H to select it, click the Format
painter icon, then click column I, and that will get the appearance the
same.
In cell I6 enter =H6
In cell I7 enter =$I$6-SUMPRODUCT(--($E$7:E7="x"),--($F$7:F7-$G$7:G7))
and copy down.
Then, if you put an x in column E (Labelled "C"), then column I will
reflect the cleared balance down to that transaction.

--
Regards

Roger Govier

"Joyce" <Joyce RemoveThis @discussions.microsoft.com> wrote in message
news:F97C26CE-2D9A-407A-9CDF-E49A284BD52B@microsoft.com...
>I like the Checkbook register template for basic use, too. Does anyone
>know
> how to add a formula to the column named "C" so that cleared checks
> can be
> checked off and my checkbook can be balanced automatically?
> --
> J.
>
>
> "JM Hazel" wrote:
>
>> I just started using the Checkbook register template and love it.
>> Until I
>> need to add some more rows, now the addition and subtraction feature
>> in the
>> Balance column doesn't work.
>> What did I do wrong?
>> How can I continue to put information in added rows and continue to
>> get the
>> Balance feature to work.
>> Thanks for your help
>> --
>> JM Hazel

Joyce · External Since: Jan 27, 2005 Posts: 34

Thanks, it took a while to "translate" your formula into the template I had
already modified to suit my needs but, it WORKED!!!
--
J.

"Roger Govier" wrote:

> Hi Joyce
>
> One way would be to add a column I called Cleared balance.
> Click on the column header for column H to select it, click the Format
> painter icon, then click column I, and that will get the appearance the
> same.
> In cell I6 enter =H6
> In cell I7 enter =$I$6-SUMPRODUCT(--($E$7:E7="x"),--($F$7:F7-$G$7:G7))
> and copy down.
> Then, if you put an x in column E (Labelled "C"), then column I will
> reflect the cleared balance down to that transaction.
>
> --
> Regards
>
> Roger Govier
>
>
> "Joyce" <Joyce.RemoveThis@discussions.microsoft.com> wrote in message
> news:F97C26CE-2D9A-407A-9CDF-E49A284BD52B@microsoft.com...
> >I like the Checkbook register template for basic use, too. Does anyone
> >know
> > how to add a formula to the column named "C" so that cleared checks
> > can be
> > checked off and my checkbook can be balanced automatically?
> > --
> > J.
> >
> >
> > "JM Hazel" wrote:
> >
> >> I just started using the Checkbook register template and love it.
> >> Until I
> >> need to add some more rows, now the addition and subtraction feature
> >> in the
> >> Balance column doesn't work.
> >> What did I do wrong?
> >> How can I continue to put information in added rows and continue to
> >> get the
> >> Balance feature to work.
> >> Thanks for your help
> >> --
> >> JM Hazel
>
>
>

Roger Govier · External Since: Feb 09, 2005 Posts: 2965

Hi Joyce

Thanks for the feedback. That's the problem when one doesn't know
anything about the layout at the other end. I just worked off the
standard template. Glad you managed to sort it all out though.

--
Regards

Roger Govier

"Joyce" <Joyce.RemoveThis@discussions.microsoft.com> wrote in message
news:3B9FA370-0A2F-4D34-8AF8-904A35A5EEA5@microsoft.com...
> Thanks, it took a while to "translate" your formula into the template
> I had
> already modified to suit my needs but, it WORKED!!!
> --
> J.
>
>
> "Roger Govier" wrote:
>
>> Hi Joyce
>>
>> One way would be to add a column I called Cleared balance.
>> Click on the column header for column H to select it, click the
>> Format
>> painter icon, then click column I, and that will get the appearance
>> the
>> same.
>> In cell I6 enter =H6
>> In cell I7 enter
>> =$I$6-SUMPRODUCT(--($E$7:E7="x"),--($F$7:F7-$G$7:G7))
>> and copy down.
>> Then, if you put an x in column E (Labelled "C"), then column I
>> will
>> reflect the cleared balance down to that transaction.
>>
>> --
>> Regards
>>
>> Roger Govier
>>
>>
>> "Joyce" <Joyce.RemoveThis@discussions.microsoft.com> wrote in message
>> news:F97C26CE-2D9A-407A-9CDF-E49A284BD52B@microsoft.com...
>> >I like the Checkbook register template for basic use, too. Does
>> >anyone
>> >know
>> > how to add a formula to the column named "C" so that cleared checks
>> > can be
>> > checked off and my checkbook can be balanced automatically?
>> > --
>> > J.
>> >
>> >
>> > "JM Hazel" wrote:
>> >
>> >> I just started using the Checkbook register template and love it.
>> >> Until I
>> >> need to add some more rows, now the addition and subtraction
>> >> feature
>> >> in the
>> >> Balance column doesn't work.
>> >> What did I do wrong?
>> >> How can I continue to put information in added rows and continue
>> >> to
>> >> get the
>> >> Balance feature to work.
>> >> Thanks for your help
>> >> --
>> >> JM Hazel
>>
>>
>>