Create pdf from excel with specific range and today's date data

He there,

Can somebady help me to change this vba or create new one. I want to create daily report with specific range and select data from colummn based on todays date.
I attached image of my schedule.
This is my vba to create monthly report.

Please Login or Register  to view this content.

Administrator's note: Please take the time to review our rules. There aren't many, and they are all important. Our guidelines recommend code tags. I have added them for you this time because you are a new member. --6StringJazzer

Please attach your actual Excel file so we can run, update, and test your code. Thanks. See yellow banner at the top of the page.

If I understand correctly, you do not need any VBA changes to do this. I provided formulas to populate the table based on today's date, and also applied the same conditional formatting rules to the day's data.

I also adjusted your day-of-week to be the date formatted as ddd rather than a formula converting it to text. I made the corresponding change in your conditional formatting to use the day-of-week number rather than the text for the day name.

Also I strongly recommend against using merged cells.

I have 12 worksheets, one for each month

This was not evident from the file you attached.

What is the daily report you want to send? Is it that table in the lower part of sheet? Will you have that on every sheet?

I recommend you have one sheet with the daily report, build it with formulas, and the VBA can generate the PDF and mail it, if that's what you need to do. But first I need to know what your report looks like.

Go to sheet Daily Report and click Send to PDF. It will refer to the correct month sheet when month is not August, if that sheet exists.