LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Inserting Rows and Maintaining Correct Balances

I'm new to Excel and am still learning. I am working in Excel 2000. What I've
done is make up a spreadsheet for my checking account which, is working quite
fine except for a little problem that I have been experiencing.

Sometimes I post payments and deposits in advance. For example I may make a
posting for a November payment and am still in the month of October. Now that
I have entered the Nov payment and, then want to add another row to put in an
October payment, I find that the balance is incorrect and, the only way to
try and correct it is to copy the previous balance and paste it. However, my
continuing balance remains incorrect.

In short, what I am trying to do is to insert rows before payments that have
already been entered and, at the same time maintain the correct balance.

Will appreciate any suggestions.

Thanks
--
Floridaguy
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide rows with zero balances LennieLou Excel Discussion (Misc queries) 10 August 8th 09 12:26 AM
Pivot Tables - Exclude Rows With Zero Balances bobs Excel Discussion (Misc queries) 2 January 10th 08 01:53 PM
HOW DO I AUTOMATICALLY DELETE ROWS WITH ZERO BALANCES? suec4 Excel Worksheet Functions 1 August 25th 06 03:17 PM
Maintaining cell references when inserting cells elsewhere Stephen Jefferson Excel Discussion (Misc queries) 3 August 5th 05 09:30 PM
How to link endings balances to beginning balances on different sh judyskiskd Excel Worksheet Functions 1 October 28th 04 07:21 PM


All times are GMT +1. The time now is 04:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"