how to list missing all date by blank row between change value cells?

[poem]

i am looking for macro code that isert blank row between data( missing all date) when change value data which each cells are started frist month if not mentied till end of month too

[Kaper]

Try such macro (not most effective but quite strightforward to understand - I hope):

Please Login or Register  to view this content.

[jindon]

Here's my interpretation of your problem.

Please Login or Register  to view this content.

[poem]

thank you too much

[jindon]

If that takes care of your original question, select Thread Tools from the menu link above and mark this thread as SOLVED.

[macropod]

Cross-posted at:
http://www.excelguru.ca/forums/showt...ge-value-cells
and:
http://www.msofficeforums.com/excel-...html#post84990