Re: Copy/Paste Cell Value to Correponding Dates Based On Month
if you would prefer a non vba solution, then this formual would do the trick
=IF($B4>C$3,IF($B4<=D$3,$A4,""),"")
This does require a leading Jul - 07 to be entered in c3 but this column can be hidden (or just this cell changed to white text) to hide this.
This formula can then be filled to all other cells and your figures will miraculously jump to the appropriate columns.
David