Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofill
Hi,
I am looking for a formula or code to fill in a range of cells with a figure on the 1st of every month, so when 1st March arrives I need cell C1 to enter £100 and when 1st April arrives I need cell D2 to £100 and so on for 12 months. Can anyone help me with this query. Many thanks Mark |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofill
Select the sheet tab which you want to work with. Right click the sheet tab
and click on 'View Code'. This will launch VBE. Paste the below code to the right blank portion. Get back to to workbook and try out. Private Sub Worksheet_Activate() If Day(Date) = 1 Then Cells(1, Month(Date)) = 100 End Sub -- Jacob "terilad" wrote: Hi, I am looking for a formula or code to fill in a range of cells with a figure on the 1st of every month, so when 1st March arrives I need cell C1 to enter £100 and when 1st April arrives I need cell D2 to £100 and so on for 12 months. Can anyone help me with this query. Many thanks Mark |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofill
Hi Jacob,
This code not doing anything for me, do I have to input cells into the code so that the cells C1, D1, E1 etc fill in withh the 100 on the ist of every month? Many thanks Mark "Jacob Skaria" wrote: Select the sheet tab which you want to work with. Right click the sheet tab and click on 'View Code'. This will launch VBE. Paste the below code to the right blank portion. Get back to to workbook and try out. Private Sub Worksheet_Activate() If Day(Date) = 1 Then Cells(1, Month(Date)) = 100 End Sub -- Jacob "terilad" wrote: Hi, I am looking for a formula or code to fill in a range of cells with a figure on the 1st of every month, so when 1st March arrives I need cell C1 to enter £100 and when 1st April arrives I need cell D2 to £100 and so on for 12 months. Can anyone help me with this query. Many thanks Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
autofill | Excel Discussion (Misc queries) | |||
Autofill UP - Is this the Best Way? | Excel Programming | |||
Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) | |||
Autofill last row | Excel Programming | |||
Q. Autofill question: Can I autofill alpha characters like I can numbers? | Excel Programming |