autofill
 

is there a function or macro that can be used to have Excel only copy or fill
a certain number of cells? For example, I want to insert dates into column A
from 1/1/1996 thru 6/30/2008. Instead of dragging the fill box, can i put a
formula into excel that will tell excel to copy down the coumn until a cell
value equals 6/30/2008?

this formula would be useful for other applications and not just for dates,
such as 1-1000, a-z, etc.

thanks!

autofill
 

Try this:

Enter 1/1/1996 in A1. With A1 as the active cell, select Edit Fill
Series. Choose Series in = Columns, Step value = 1, and Stop value =
6/30/2008, then click OK.

Hope this helps,

Hutch

"scott" wrote:

is there a function or macro that can be used to have Excel only copy or fill
a certain number of cells? For example, I want to insert dates into column A
from 1/1/1996 thru 6/30/2008. Instead of dragging the fill box, can i put a
formula into excel that will tell excel to copy down the coumn until a cell
value equals 6/30/2008?

this formula would be useful for other applications and not just for dates,
such as 1-1000, a-z, etc.

thanks!

autofill
 

Alternatively, you can use a formula saying:

if(previous date+1<6/30/2008,previous date+1,"")

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"scott" wrote in message
...
is there a function or macro that can be used to have Excel only copy or
fill
a certain number of cells? For example, I want to insert dates into
column A
from 1/1/1996 thru 6/30/2008. Instead of dragging the fill box, can i put
a
formula into excel that will tell excel to copy down the coumn until a
cell
value equals 6/30/2008?

this formula would be useful for other applications and not just for
dates,
such as 1-1000, a-z, etc.

thanks!