Hi xld,

Thank you for your response. I tried the above code you suggested. When I run the macro second time (after cell "A1" has data for the first Job # say J0001) for Job # J0002, the entries for first Job # (J0001) are shifted to right side of the spreadsheet starting from column "J". I want the first job entry to move down instead of moving on right.

Thanks