Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto filling dates
I have a spreadsheet that has the date in Column B. It starts off in
Cell 15 as 1/4/09, Cell 16 is 1/5/09 . . . Cell 21 is 1/10, Cell 22 is blank, and Cell 23 starts the week over (1/11.) As you can see, I have 7 Cells with dates, then a blank cell. 1/4/09 1/5/09 1/6/09 1/709 1/8/09 1/9/09 1/10/09 BLANK 1/11/09 etc The way I've been entering the information so far is by hand. If I didn't have a blank cell I know I could enter a couple of dates and then click and drag to complete the year, but because of the blank cell I don't know if I can automate the task or not. Can I? Thank you. Chip |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto filling dates
You could enter them all the way you mention and insert blank rows later
or How about a VBA subroutine to do the whole job? Would that interest you? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email wrote in message ... I have a spreadsheet that has the date in Column B. It starts off in Cell 15 as 1/4/09, Cell 16 is 1/5/09 . . . Cell 21 is 1/10, Cell 22 is blank, and Cell 23 starts the week over (1/11.) As you can see, I have 7 Cells with dates, then a blank cell. 1/4/09 1/5/09 1/6/09 1/709 1/8/09 1/9/09 1/10/09 BLANK 1/11/09 etc The way I've been entering the information so far is by hand. If I didn't have a blank cell I know I could enter a couple of dates and then click and drag to complete the year, but because of the blank cell I don't know if I can automate the task or not. Can I? Thank you. Chip |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto filling dates
On Jul 10, 12:03*pm, "Bernard Liengme" wrote:
You could enter them all the way you mention and insert blank rows later or How about a VBA subroutine to do the whole job? Would that interest you? best wishes -- Bernard V Liengme Microsoft Excel MVPhttp://people.stfx.ca/bliengme remove caps from email wrote in message ... I have a spreadsheet that has the date in Column B. It starts off in Cell 15 as 1/4/09, Cell 16 is 1/5/09 . . . Cell 21 is 1/10, Cell 22 is blank, and Cell 23 starts the week over (1/11.) As you can see, I have 7 Cells with dates, then a blank cell. 1/4/09 1/5/09 1/6/09 1/709 1/8/09 1/9/09 1/10/09 BLANK 1/11/09 etc The way I've been entering the information so far is by hand. If I didn't have a blank cell I know I could enter a couple of dates and then click and drag to complete the year, but because of the blank cell I don't know if I can automate the task or not. Can I? Thank you. Chip I don't know anything about VBA; I've only know what it stands for. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto filling semi-monthly dates | New Users to Excel | |||
Auto Filling | Excel Worksheet Functions | |||
Auto filling a row | Excel Discussion (Misc queries) | |||
Auto Protecting cells & auto filling date | Excel Discussion (Misc queries) | |||
Auto filling dates on other worksheets with data from a next payme | Excel Worksheet Functions |