Excel : fill by example
Hi
Is there a similar function to the Lotus 1-2-3 "fill by example". I've
tried the Fill option under Edit, however can't seem to get it to work with
dates. For example if I enter in 3 dates in a column (see example below), I
would then like the next 20 or so rows for that column to be filled in with
dates incrementing by one week.
e.g
31.10.2005
07.11.2005
14.11.2005
thanks in advance.
Steven
|