Auto Post Day of Month Entry

[John775]

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.

[John775]

Sorry for the trouble.

[Logit]

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

[John775]

I will try to figure it out.

[Logit]

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

Please Login or Register  to view this content.

[John775]

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.

[John775]

I sorted the column so the dates are in order of proposed lines entries when the day of the month happens not before. So today there is one entry for the internet that should auto fill.

Thank you for the help

[Logit]

.
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 :

Please Login or Register  to view this content.

[John775]

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.

[John775]

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

[Logit]

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

Please Login or Register  to view this content.

Then, in the ThisWorkbook module, paste this macro :

Please Login or Register  to view this content.

Note the comments in the TodayDate macro :

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

[John775]

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 ?

[Logit]

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

[John775]

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

Okay I will revise the book in the morning thanks.

[John775]

I converted tables to ranges and saved workbook as 3.1 version closed it and reopened. The entries aren't filling in still. If you have a chance can you check it please?

Sheet2 is referenced in the code but that is the Jan! sheet. Could that be the issue?

Thank you

PS I changed the sheet to Sheet17 and it posted today's row. But it posted it multiple times and in the date column it has the number 4 and not the date. Can you please fix?