Auto Post Day of Month Entry

Hello is it possible to automatically post to my Entries! sheet from the Recurring Log! sheet every month based on the day of the month in column A on the Entries! sheet?

Thank you very much for any help.

Sorry for the trouble.

.
Don't be impatient. Sometimes, answers are given hours or days later.

I will try to figure it out.

.
If you paste this in the Recurring Log sheet module, it will copy everything to the Entries sheet, everytime you type something.
.

Option Explicit

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Sheets("Recurring Log").Range("A1:Z1000").Copy Destination:=Sheets("Entries").Range("A1")
    Application.CutCopyMode = False
End Sub

Thank you for the code. I was looking for entries to be made based on the date. For instance today is the 1st so the row with a 1 in the column should post.

.
In order to have your selection copied / paste from one sheet to another, I had to remove the table you established on both sheets.

If you desire to have every other row color coded, you can do that via another macro and not use a table.

Here is the code that will copy/paste rows found based on the number you enter into the Inputbox :

Option Explicit

Sub filterTerm()
Dim ValToCopy As String
ValToCopy = InputBox("Enter number to find: ", "What Date Number ?")

Application.ScreenUpdating = False
    Columns(1).AutoFilter 1, ValToCopy                     
    With Range("A3", Range("i" & Rows.Count).End(3))        
        .Copy Sheet2.Cells(Rows.Count, 1).End(3).Offset(1)  
    End With
    Columns(1).AutoFilter                                   
Application.ScreenUpdating = True

End Sub

Thank you so much for helping. I revised the book and hopefully you can understand my request now. The yellow areas on the Entries! sheet should be rows 4 & 5 since the designated 3 matches today's day number.

The Entries sheet should have the date in column A. This process should repeat so each month has the entries when the day happens.

.
To automate the process, delete the Sub filterTerm () macro and replace it with this macro :

Option Explicit

Sub TodayDate()
    Dim daterng As Range
    Dim DateCell As Range
    Dim WorkSht As Worksheet
    Dim dateStr As String
    Application.ScreenUpdating = False
    
    'To display ONLY THE CURRENT DAY in "Entries Sheet" ... uncomment the next three lines
    'Sheets("Entries").Activate
    'Sheets("Entries").Range("A3:A50").EntireRow.Delete
    'Sheets("Recurring Log").Activate
    
    With Sheets("Recurring Log")
    
        Set daterng = Range("A1:A100")
        
        For Each DateCell In daterng
            DateCell.Activate
            ActiveCell.Select
            On Error Resume Next
            dateStr = DateCell.Value
            
            If dateStr = Day(Now) Then
                DateCell.EntireRow.Copy Sheet2.Cells(Rows.Count, 1).End(3).Offset(1)
            End If
        Next
        
        End With
        
    Sheets("Entries").Activate
    Sheets("Entries").Range("A3").Select

    Application.ScreenUpdating = True
End Sub

Then, in the ThisWorkbook module, paste this macro :

Option Explicit

Private Sub Workbook_Open()
    TodayDate
End Sub

Note the comments in the TodayDate macro :

 'To display ONLY THE CURRENT DAY in "Entries Sheet" ... uncomment the next three lines
    'Sheets("Entries").Activate
    'Sheets("Entries").Range("A3:A50").EntireRow.Delete
    'Sheets("Recurring Log").Activate

If you ONLY WANT TO SEE THE CURRENT DAY entries, uncomment the three lines. It will look like this :

 'To display ONLY THE CURRENT DAY in "Entries Sheet" ... uncomment the next three lines
    Sheets("Entries").Activate
    Sheets("Entries").Range("A3:A50").EntireRow.Delete
    Sheets("Recurring Log").Activate

Hello Logit and thank you very much. I made some updates to my workbook and then tried this new code in it. I know it is something I'm doing wrong. Can you please take a look at the workbook ?

.
Your workbook has TABLES.. The macro posted wont work with TABLES.

Originally Posted by Logit

.
Your workbook has TABLES.. The macro posted wont work with TABLES.

Okay I will revise the book in the morning thanks.