Macro to collect YTD data. I think I have most of it . . .

I'm trying to get YTD totals per each month via a macro and then post to a cells where I can set a range for a YTD chart. I get zero's when I run the macro. The code below is for one month, then would be repeated for each month. Any help is much appreciated!

Please Login or Register  to view this content.

Thank you!

Luke

That looks like it works to me. Can you upload a workbook with an example of how your data is structured? To attach a workbook when replying click go advanced and then attachments.

YTD data.xlsm

Here you go.
Thanks for any help.

Luke

Any other advice is much appreciated. This should be the last VB fix I need before implementing the program. Thank you!!!!
- Luke

The values in the cells are dates not months. So for example, the date is 04/01/2012 and you have a custom format to display only the month. VBA will still compare "04/01/2012" not what you see on the screen. Try this instead:

Please Login or Register  to view this content.