|
|
#8
05-03-2012, 02:26 AM
|
||||
|
||||
Hi cjaye,
See attached. All you need to do is to insert each month's data on the 'Mileage History' sheet. Even the dates on that sheet are calculated automatically by copying the formula in column A down. Assuming you have more vehicles to monitor, simply add extra columns for them on the 'Mileage History' sheet and copy columns A:G on the 'Main' sheet.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Displaying cell data in another spreadsheet | Colonel Biggs | Excel | 0 | 07-01-2010 07:37 PM |
| Client Payment History | GMatos78 | Office | 0 | 04-22-2010 03:40 PM |
 Data Set Display Size - PP 2007
|
TonyMan | PowerPoint | 1 | 04-14-2010 05:45 AM |
| Displaying data from spreadsheet in Userform | darklide | Excel | 0 | 03-12-2010 05:42 AM |
| CAUTION!! Sorting a spreadsheet with hidden columns will trash your data. | psmaster@earthlink.net | Excel | 0 | 11-24-2009 11:54 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode