Hi, I've been stuck on this a long time and hopefully someone can figure this out. I've tried pivot tables but its not visually acceptable here unfortunately. So I hope someone can write a macro to solve it.

Column A has dates which i need the macro to detect and calculate monthly returns from Column B. The figures should go into a table as shown

eg. for March 2009----detect that month started at Row 2 and ended Row 23.......so calculate (B23-B2)/B2....which is about -1%.


thanks
i will be extremely grateful if this is somehow solved, although i have low expectations of that