Help request to get tomorrow list

[mso3]

Hi friends,

Today is 31/07/2016 & there is a birthday of my friend tomorrow 01/08/2016. I’m not getting a output with tomorrow’s birthday if I run the macro on the last day of month. As a result I’m not getting a list of tomorrow’s birthday on the last month of day.

Please see the following code and suggest me an amendment to achieve the target ‘birthday tomorrow’.

Please Login or Register  to view this content.

Any help will be highly appreciated.

Thanking you in anticipation.

[bakerman2]

Try this.

Please Login or Register  to view this content.

[anrichards22]

Maybe something like this:

Please Login or Register  to view this content.

Which tests to see if date is the last day of the month, if it is then filtermonth is the month + 1 otherwise filtermonth is the current month.

[mso3]

Hi bakerman2,

Greetings from me!

Thank you. There is not a helping column for next month and day tomorrow for next month. So I'm not getting output.

Is there a need to add 2 helping columns for next month and day tomorrow next month?

Do you have any other idea to achieve the target?

[mso3]

Hi anrichards22,

Thank you.

I'm getting compile error 'sub or function not define'

[anrichards22]

Maybe try like this:

Please Login or Register  to view this content.

[bakerman2]

My suggestion would be to build small userform to give user the oppurtunity to select month and begin and end date and build your filtercriteria from there on.

[mso3]

Ok, The error has gone but no output.

Is there a need to insert another 2 helping columns to filter next month and the next day month? And create 2 filters for it?

[anrichards22]

Please Login or Register  to view this content.

[mso3]

Post Deleted.

[mso3]

Excellent! Now the macro is working fine as per requirement.

Thank you and have a nice time.