Auto insert a number of rows
 

Hi

In Excel 2000 I need to find a method of inserting a number of blank rows.

My sheet has a list of names in column A. Columns B to P are headed as a
number of different items and there is an entry under each heading. If the
entry is either 'Y' or a value greater than 0 I need to insert a blank line
below the name in a so that I can transpose the entries from the row into a
column. Having done this for the first name I have to repeat this process
for the list of names until complete. Each name will have a different number
of entries under the headigs B to P.

Thanks for any assistance.

Gareth