On Oct 16, 2:59*am, "Rick Rothstein"
wrote:
I believe this array-entered** formula will do what you want...

=INDEX(C:C,MATCH(ROW(A1),MONTH(A$1:A$2500)))

** Commit the formula using Ctrl+Shift+Enter, not just Enter by itself

Place the formula in a cell, change the 2500 row reference to the maximum
row number you ever expect to have data in, and then copy it down for 11
more rows.

How would I do this with VBA?

Travis