Autofill

T

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
 
J

Jacob Skaria

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
 
T

terilad

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autofill Data 3
auto fill data 1
comparing two columns in vba 2
Date Variable 1
create a formula to know last months column character or number 0
Set Up Calendar To Account For Leap Years 2
Conditional formula's in excel-calculating with dates / age andaffiliation date calculus 3
Count occurances in a range. 5

Top