| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofill Data
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 Data
Hi ,
Please try this formular in cell C1 till L1 or as need. =IF(MONTH(TODAY())=COLUMN(C1),100,0) "terilad" เขียน: 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 Data
Hi,
Thats not working for me when I enter the formula even when it is before the current date it fills in 100, any ideas? Regards Mark "Lamunphan" wrote: Hi , Please try this formular in cell C1 till L1 or as need. =IF(MONTH(TODAY())=COLUMN(C1),100,0) "terilad" เขียน: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Autofill Data
Fixed it, just tweeked your code a little, took out MONTH and COLUMN and got
it working. Thankyou for your help. Regards Mark "Lamunphan" wrote: Hi , Please try this formular in cell C1 till L1 or as need. =IF(MONTH(TODAY())=COLUMN(C1),100,0) "terilad" เขียน: 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 data in cell with other existing data. | Excel Discussion (Misc queries) | |||
| AUTOFILL DATA | Excel Discussion (Misc queries) | |||
| Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) | |||
| Q. Autofill question: Can I autofill alpha characters like I can numbers? | Excel Programming | |||
| Macro that will autofill a column with data, up to the last row of data in previous c | Excel Programming | |||
Linear Mode
