+ Reply to Thread
Results 1 to 7 of 7

Checkbook register problem

  1. #1
    Registered User
    Join Date
    10-12-2019
    Location
    AZ
    MS-Off Ver
    Think3 office free
    Posts
    4

    Checkbook register problem

    I have used this forum and it has helped me make a checkbook with running balances. However, if I need to insert a new row, lets say in the middle of the register because it is to follow a certain date, how do I configure the complete register to add or subtract from that new row and down? I am lost. Thank you,
    Gary

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Checkbook register problem

    Do you mean that if you insert a new row, the formulae automatically populate into that row??

    If so, simply turn your data block into a Table...
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    10-12-2019
    Location
    AZ
    MS-Off Ver
    Think3 office free
    Posts
    4

    Re: Checkbook register problem

    Thank you....I'll give the "Table" idea a try when I get home from work this afternoon and will let you know. I appreciate your taking the time to reply.

  4. #4
    Registered User
    Join Date
    10-12-2019
    Location
    AZ
    MS-Off Ver
    Think3 office free
    Posts
    4

    Re: Checkbook register problem

    I just tried to download the link you sent to me but cannot do so as I get an error window saying I do not have an app associated with it for performing the action ???

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Checkbook register problem

    It's just a simple Excel sheet with 2 columns, in a Table. One of the columns has a value and the other a formula. That's all.... Saved it again and attached it again.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    10-12-2019
    Location
    AZ
    MS-Off Ver
    Think3 office free
    Posts
    4

    Re: Checkbook register problem

    Thanks but I do not know anything about tables and the link is still not working

  7. #7
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Checkbook register problem

    Downloads ok for me. Are you running a machine with Windows installed?

    Here is a link tutorial on Tables--->https://support.office.com/en-us/art...9-6c94334e492c
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Checkbook Register for AD&D 1e
    By Wrenn in forum Excel General
    Replies: 3
    Last Post: 05-23-2017, 09:49 AM
  2. checkbook register
    By lynnbuff in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 07-25-2006, 03:25 PM
  3. Checkbook Register
    By PurpleBabs in forum Excel General
    Replies: 5
    Last Post: 04-25-2006, 07:10 PM
  4. Checkbook Register template
    By PurpleBabs in forum Excel General
    Replies: 5
    Last Post: 04-21-2006, 12:15 AM
  5. [SOLVED] Spreadsheet like checkbook register
    By Bobby B in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 09-30-2005, 12:05 PM
  6. [SOLVED] checkbook register template
    By dexcelled in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-09-2005, 01:06 AM
  7. How do I create a checkbook register?
    By Cumquat in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 01-02-2005, 09:07 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1