+ Reply to Thread
Results 1 to 6 of 6

Excel 365 Check Register Calculation Question

  1. 03-27-2024, 11:05 PM #1
    slimpickinz
    slimpickinz is offline
    Registered User
    Join Date
    03-27-2024
    Location
    Dayton OH
    MS-Off Ver
    365
    Posts
    2

    Excel 365 Check Register Calculation Question

    Hi everyone. Been a long time since I posted but have a question...
    I have this simple monthly check register which calculated my balance with formulas.
    What I would like to do is copy the last calculated cell on a sheet (say April) to the first cell in the last column of the next sheet (May).
    Specifically, in the attached workbook, this would be H2.
    Since each month the row count will be different, I am having trouble figuring out how to pull the value from the last calculated cell in row H to that cell I mentioned above (H2) of the previous month.
    Thanks in advance for the nudge in the right direction!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-27-2024, 11:48 PM #2
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Excel 365 Check Register Calculation Question

    This would be easier if you used actual dates to title the sheets in cell D1, but can be done. You also need to be consistent in how you abbreviate the months. April, June, and July are spelled out but the others are three letters, except September is 4 letters. That makes it very hard to do this with a formula.

    I am making all your tab names 3 letters. See formula in H2. Same formula in every sheet.
    Attached Files Attached Files
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]
    Reply With QuoteRegister To Reply
  3. 03-28-2024, 01:09 AM #3
    DJunqueira
    DJunqueira is offline
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: Excel 365 Check Register Calculation Question

    Some other formulas that you could use.
    H2
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    Column H
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    I agree with Jeff that you need to have a pattern for your tabs.
    Reply With QuoteRegister To Reply
  4. 03-28-2024, 02:10 AM #4
    shukla.ankur281190
    shukla.ankur281190 is offline
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Excel 365 Check Register Calculation Question

    Or try

    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    Please change the sheet name April to Apr as MMM format
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Reply With QuoteRegister To Reply
  5. 03-28-2024, 01:32 PM #5
    slimpickinz
    slimpickinz is offline
    Registered User
    Join Date
    03-27-2024
    Location
    Dayton OH
    MS-Off Ver
    365
    Posts
    2

    Re: Excel 365 Check Register Calculation Question

    Thanks so much for everyone's help on this!
    All the above seem to work as needed.
    Appreciate the advice on formatting the tabs as well!
    Reply With QuoteRegister To Reply
  6. 03-28-2024, 03:03 PM #6
    DJunqueira
    DJunqueira is offline
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: Excel 365 Check Register Calculation Question

    Tks for the feedback, glad to help.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help! Need Check Register
    By bookbuyer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-30-2016, 05:43 PM
  2. Excel 2007 : Using excel as check register and it will no longer sum
    By doggysit in forum Excel General
    Replies: 1
    Last Post: 04-10-2012, 09:03 PM
  3. set up a worksheet in excel like a check register with auto sum
    By jthhousing in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-30-2006, 09:25 PM
  4. [SOLVED] lengthen check register on Excel
    By Todd in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 08-08-2005, 02:28 PM
  5. check register with Excel
    By dbigdog88 in forum Excel General
    Replies: 3
    Last Post: 06-11-2005, 01:05 PM
  6. Help with my check register please
    By David A in forum Excel General
    Replies: 0
    Last Post: 01-12-2005, 09:08 PM
  7. Where are instructions for using Check Register template in Excel.
    By Victoria in forum Excel General
    Replies: 0
    Last Post: 01-05-2005, 03:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1