Thank you very much StringJazzer for providing your formula.
I have 12 worksheets, one for each month, and I want to send as pdf only daily report. To send monthly report I use vba code that I provided on first post. To send daily report with your idea, i must create other 12 sub sheets, get data with your formula from main sheet. VBA code will be more usefull for me.