software

Excel XP

Am trying to fill a series of dates such as:1/1
1/2
1/3
1/4
1/51/8
1/9
1/10
1/11
1/12

First date in cell a3. By selecting cells a1:a14 I can get Excel to
leave the two blank cells but cannot get it to skip the 1/6, 1/7 dates. In
the next series Excel picks up with the 1/6 date.Is it possible to have
Excel quot;skipquot; dates with autofill?

Walter Mayes
Hi Walter,

I am using Excel 2003 at the moment so cannot test what you have said. But
one way around it which would work on XP would be to...

- fill your series down how ever many times you need it for,
- put an autofilter into column A (select column A and then add your filter
to pick up ALL values in column A, including blanks between data)
- Filter out 01/06 OR 01/07 using the custom filter
- clear these values (do not delete the rows, just clear the values)
- take off your filter, and hey presto.......Hope this helps....

Bhupinder
quot;Walter Mayesquot; wrote:

gt; Excel XP
gt;
gt; Am trying to fill a series of dates such as:
gt;
gt;
gt; 1/1
gt; 1/2
gt; 1/3
gt; 1/4
gt; 1/5
gt;
gt;
gt; 1/8
gt; 1/9
gt; 1/10
gt; 1/11
gt; 1/12
gt;
gt; First date in cell a3. By selecting cells a1:a14 I can get Excel to
gt; leave the two blank cells but cannot get it to skip the 1/6, 1/7 dates. In
gt; the next series Excel picks up with the 1/6 date.Is it possible to have
gt; Excel quot;skipquot; dates with autofill?
gt;
gt; Walter Mayes
gt;
gt;
gt;

Thanks for the suggestion. I'll give it a shot.

Walter Mayes

quot;Bhupinder Rayatquot; wrote in message
Hi Walter,

gt; I am using Excel 2003 at the moment so cannot test what you have said.
gt; But
gt; one way around it which would work on XP would be to...
gt;
gt; - fill your series down how ever many times you need it for,
gt; - put an autofilter into column A (select column A and then add your
gt; filter
gt; to pick up ALL values in column A, including blanks between data)
gt; - Filter out 01/06 OR 01/07 using the custom filter
gt; - clear these values (do not delete the rows, just clear the values)
gt; - take off your filter, and hey presto.......
gt;
gt;
gt; Hope this helps....
gt;
gt; Bhupinder
gt; quot;Walter Mayesquot; wrote:
gt;
gt;gt; Excel XP
gt;gt;
gt;gt; Am trying to fill a series of dates such as:
gt;gt;
gt;gt;
gt;gt; 1/1
gt;gt; 1/2
gt;gt; 1/3
gt;gt; 1/4
gt;gt; 1/5
gt;gt;
gt;gt;
gt;gt; 1/8
gt;gt; 1/9
gt;gt; 1/10
gt;gt; 1/11
gt;gt; 1/12
gt;gt;
gt;gt; First date in cell a3. By selecting cells a1:a14 I can get Excel to
gt;gt; leave the two blank cells but cannot get it to skip the 1/6, 1/7 dates.
gt;gt; In
gt;gt; the next series Excel picks up with the 1/6 date.Is it possible to have
gt;gt; Excel quot;skipquot; dates with autofill?
gt;gt;
gt;gt; Walter Mayes
gt;gt;
gt;gt;
gt;gt;