Gord's macro will work, as written, if your part numbers are in col A. If
not, modify to suit.

--
Don Guillett
SalesAid Software

"rajeev" wrote in message
oups.com...
Thanks lot Gord at last i have got it but i am
facing a new problem.The macro creates a gap of 5 rows between every
part no.However i want to create a gap only when the part no.
changes.Suppose if 3 rows are occupied by same part no. then i want
that macro should run only after that part no. changes.
However once again thanks lot for solving substantial portion of my
problem.

Rajeev