Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
is there a way to post dates without enetering 1 by 1 into cell
im looking for a way to enter dates for a whole Fiscal Year without entering
each date one by one into the A column. Or any ways to post a whole month at a time. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
is there a way to post dates without enetering 1 by 1 into cell
Enter your first date in a cell.
Then, *right* click and drag down, using the fill handle, as far as needed. When you release the mouse, you will see many options to choose from. Also, click on the last option (Series), for a *lot* more choices. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "dustin" wrote in message ... im looking for a way to enter dates for a whole Fiscal Year without entering each date one by one into the A column. Or any ways to post a whole month at a time. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
is there a way to post dates without enetering 1 by 1 into cell
Here's one way:
I don't know when YOUR fy is so I'll use a calander year as an example. Enter the first date in A1: A1 = 1/1/2006 Select column A Goto EditFillSeries Series in: Columns Type: date Date unit: Day Step value: 1 Stop value: 12/31/2006 (in your case enter the last date of your fy) OK Biff "dustin" wrote in message ... im looking for a way to enter dates for a whole Fiscal Year without entering each date one by one into the A column. Or any ways to post a whole month at a time. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
is there a way to post dates without enetering 1 by 1 into cell
Hi Dustin, I'm a newbie too, been learnin' a lot here though.
I have this little bit of code that will enter the current date in a cell when clicked, though you can put any date you want in that cell (until you click it again, thenit goes to current) here it is: 'Automatically inserts today's date in cell in column C when selected 'if the cell was empty. Does not overwrite occupied cell. If you want a different column then change the "ActiveCell.column= XX" to whatever number you want. i.e. A=1B=2C=3etc. Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If ActiveCell.Column = 3 Then 'Limits macro action to column C If ActiveCell.Value = "" Then 'Check to see if Target cell empty Selection.Value = Date 'Insert today's date in Target cell End If Else End If End Sub Hope this helps you some, larry "dustin" wrote: im looking for a way to enter dates for a whole Fiscal Year without entering each date one by one into the A column. Or any ways to post a whole month at a time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert date | Excel Worksheet Functions | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Multiple dates, times, or formulas in a single cell | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions |