i have a worksheet of vendor account details. in one column there are vendor
numbers & some vendors have 5 line items some have10,15,50,etc i.e. line
items are different. Now the problem is every month i have to prepare vendors
template and i have to insert 5 rows after every change in vendor number in
vendor column.

right now i am going manually at each vendor change and inserting rows as
detail above, there are about 700 vendors. this is not only time consuming
but frustating job.

so there any way to develop macro for this or any other way so that by
giving one command the above problem can be sorted out

thanks a lot in advnace.....