Thanks Martin and Phillip. Really appreciate yourhelp.

Both codes work! Thanks so much! Martin's code only insert one row
though.

I do have another question with the codes by the way:

The code seems to run until the limit of the HPageBreak is reach
(around 1000).
Is there someway to reduce that so macro will stop when there's no more
entry to cell?

Thanks once again!!!!
Ame