Need to get cell contents twice a month.

  • Thread starter Thread starter Barney
  • Start date Start date
B

Barney

How can I get cell contents on the 1st and 15th of each
month and automatically enter those contents in another
cell.

Thanks,

Barney
 
Barney,

see my reply to mill_rat under "Re:creating a list with dates from a single
cell"

You will need to modify the code so that it reads the correct cell(s) and
tests to see if today's date is either 1st or 15th.

add below Private Sub Workbook_open()
If Day(Now) = 1 Or Day(Now) = 15 Then

add above End Sub
End if

This will add the values every time the workbook is opened on either the 1st
or 15th, so you will get multiple entries if you open the workbook multiple
times.

There is a way to avoid this and if you need that coding, then please
re-post

Steve
 
Thanks for your help Steve. After evaluation your words
it seems it will be just as easy for me to make a note in
my calendar to make the changes manually. I only need
make two entrees twice a month.

Barney
 
Back
Top