| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.functions
|
|||
|
|||
filling a column with consecutive months
I would like to have users enter a mm/yy in one cell and the
following 359 cells in the same column will be automatically filled with the subsequent months. What is the formula to be used? Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
filling a column with consecutive months
Hi John
Do you know exactly what cell the person will be entering data? If for example they are entering dates in Cell A2, then this vba coding will work. If not I am sure you can adjust to suit. Sub Filldown() Application.ScreenUpdating = False Range("A2").AutoFill Destination:=Range("A2:A360") End Sub Take care Marcus John Smith wrote: I would like to have users enter a mm/yy in one cell and the following 359 cells in the same column will be automatically filled with the subsequent months. What is the formula to be used? Thanks. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
filling a column with consecutive months
Sorry, forgot to mention that I'd like to also increase the month.
Is there an easy way to do that? I tried to use the formula "=R[-1]C + 30". That did not work. marcus wrote: Hi John Do you know exactly what cell the person will be entering data? If for example they are entering dates in Cell A2, then this vba coding will work. If not I am sure you can adjust to suit. Sub Filldown() Application.ScreenUpdating = False Range("A2").AutoFill Destination:=Range("A2:A360") End Sub Take care Marcus John Smith wrote: I would like to have users enter a mm/yy in one cell and the following 359 cells in the same column will be automatically filled with the subsequent months. What is the formula to be used? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Best 3 Consecutive Months | Excel Worksheet Functions | |||
| How do I pull data for consecutive months in an Excel spreadsheet | Excel Worksheet Functions | |||
| Counting Consecutive Months in Top Third | Excel Worksheet Functions | |||
| Code for auto filling in Excel based on number of months, & start date | Excel Programming | |||
| i need to add consecutive months and keep the day the same for ea. | Excel Worksheet Functions | |||
Linear Mode
