Sir T Fireball Posted February 20, 2004 Report Share Posted February 20, 2004 Hi all,I am a total novice when it comes to Excel. Am trying to create what I think is a basic sheet, but have hit a wall.I have 3 columns; spent, paid and owe. I want the 'owe' column to automatically adjust after an entry in the spend or paid columns is made. Any help appreciated.Thanks :) Quote Link to comment Share on other sites More sharing options...
Chris Posted February 20, 2004 Report Share Posted February 20, 2004 Add the excel file as an attachment?You can make up figures if you like just for an example. Quote Link to comment Share on other sites More sharing options...
Sir T Fireball Posted February 20, 2004 Author Report Share Posted February 20, 2004 Can't add it. Says cannot upload this type of file. Could I email you a copy? Quote Link to comment Share on other sites More sharing options...
Chris Posted February 20, 2004 Report Share Posted February 20, 2004 Stick it in a zip folder. Quote Link to comment Share on other sites More sharing options...
Sir T Fireball Posted February 20, 2004 Author Report Share Posted February 20, 2004 ok will try :unsure:Balance_Sheet11.zip Quote Link to comment Share on other sites More sharing options...
Chris Posted February 20, 2004 Report Share Posted February 20, 2004 Unless i'm missing something when you make an entry in the PAID and COST the OWED automtically adjusts? Quote Link to comment Share on other sites More sharing options...
Sir T Fireball Posted February 20, 2004 Author Report Share Posted February 20, 2004 Did you try making a few entries further down? The 1st line works, but the rest...... :( Quote Link to comment Share on other sites More sharing options...
Chris Posted February 20, 2004 Report Share Posted February 20, 2004 That is because there is no formula in the cells.I'm sure there is a very quick way to do it, but i dont know how :( Get manualling! Quote Link to comment Share on other sites More sharing options...
Sir T Fireball Posted February 20, 2004 Author Report Share Posted February 20, 2004 ok thanks for trying :) Quote Link to comment Share on other sites More sharing options...
Sir Radfordin Posted February 20, 2004 Report Share Posted February 20, 2004 In Column G do you want it to show what you owe for the line (so Line 1 cost £100, you have paid £25 and owe 75, and Line 2 cost £50, you have paid nothing so owe £50) or do you want it to be the total owed - because you have that value at the bottom.If you fill in a sheet with the values you want to have then it would give me at least a better idea of what you are doing and can then work out how to do it using calculations! Quote Link to comment Share on other sites More sharing options...
Sir T Fireball Posted February 20, 2004 Author Report Share Posted February 20, 2004 I want total owed.Here is a link to the sheet as you requested (I hope) :Pedit: I also want to avoid having to enter £0 in empty cells as well as do away with all those #VALUE! things on view. :rolleyes:Balance_Sheet11.zip Quote Link to comment Share on other sites More sharing options...
Sir T Fireball Posted February 20, 2004 Author Report Share Posted February 20, 2004 panic over! all sorted :P Here is the final solution....Thanks to all those who aided and abetted :)Balance_Sheet11Rev1.zip Quote Link to comment Share on other sites More sharing options...
Sir Radfordin Posted February 20, 2004 Report Share Posted February 20, 2004 Should there not be some -ve values in there somewhere?? Quote Link to comment Share on other sites More sharing options...
Sir T Fireball Posted February 20, 2004 Author Report Share Posted February 20, 2004 I hope you are not asking me :P Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.