View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
XLXPertWannabe XLXPertWannabe is offline
external usenet poster
 
Posts: 6
Default Autofill time schedule with gaps EDIT

Thank you! It looks like I have a lot to learn.
With appreciation, S

"Robert McCurdy" wrote:


"XLXPertWannabe" wrote in message
...
I forgot to mention that although I can get Aotofill to use the correct
time
increments, it inserts in every cell, not in every other. Thanks again.


There's a good reason for that, so don't do it!
Blank rows or columns within your data cripple XLs analytical features.
Check out the LIST subject; Basically this means the same type of data for
each column (fields), and 1 to 1 data for rows (records).
So I could have read 100 books, so that is a different table, I have 1 name,
1 age, a person has 1 appointment at a TIME!

Date Start Time Who Reason Where End Time Charge
15/5/2008 01:00PM G Bush Brain scan Iraq 01:05PM
$1,000,000

Are some examples of headers for your data.
*Who*, should also be included in a separate data table for your customer
database.
I hope this makes some sense.

Regards
Robert McCurdy