Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoFill | Excel Worksheet Functions | |||
autofill | Excel Discussion (Misc queries) | |||
AutoFill | Excel Discussion (Misc queries) | |||
AutoFill | New Users to Excel | |||
Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) |