Question about Computers & Internet
I NEED TO HAVE THE DATE COLUMN TO UPDATE ITSELF
AND THE TOTALS HAVE TO ADD ITSELF OTHER INFO WILL BE KEYED IN ON DAILY BASIS I.E. INVOICES PAID ETC.
Best thing to do is go get a basic book on excel and learn the basics. I'm not sure exactly what you are trying to set up, but if it is a simple invoice type thing then you could go to microsoft and download templates to use already set up for you. You can even put in your own logos.
Posted on May 21, 2009
I am assuming that you want your date column to run daily - not updating itself with todays date over previous data....
In which case your column will run a daily date, You can achieve this by typing a date in the format you choose = 01/05/09, 1 May 09, etc hit return. scroll on the bottom corner of the cell you have typed the date in until it changes from a large white cross to a smaller cross and drag this down the column.
For the totals that need to subtotal autmoatically you will need to select a range - so is this total a weekly/ monthly total - How large is your range.
Once you have decided on the above - for example the in Column A the date ranges from 1st May - 31st May for a calendar month, the subtotal will need to include 31 cells - so in the Column B which is the subtotal = SUM(B2:B32)
You can copy and paste the sum into adjoining cells if you are seperating income from expenses etc.
Hope this helps.
Posted on May 21, 2009
a 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of.(from cars to computers, handyman, and even drones)
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
May 06, 2016 | Casio Office Equipment & Supplies
Apr 06, 2010 | Microsoft Office Excel 2003 for PC
Nov 13, 2009 | Computers & Internet
Aug 02, 2009 | Microsoft Office Excel 2007
Jun 18, 2009 | Microsoft Excel for PC
Feb 25, 2009 | Computers & Internet
Jul 14, 2008 | Microsoft Computers & Internet
Jan 16, 2008 | Computers & Internet
100 people viewed this question
Usually answered in minutes!