Thanks for your help on this

"Jay" wrote:

I have a worksheet (Data) that contains a set of criteria for evaluating a
given subject (aprox 100+ evaluation points). Each of the pieces of criteria
can have 1 of 4 different values (0-3). If the value is = 1, 2, or 3 a
comment regarding that point must be input into the column beside the value.

These criteria & their rankings are also broken down and displayed in one of
several other worksheets in the workbook to allow for easier review (say
points 1 - 20 are in worksheet A, 21-40 are in worksheet B, etc...).

My goal is to display the comments from the "Data" worksheet that are
associated with each piece of criteria on worksheet A, B, etc... without
having to reserve lines 20 lines on each worksheet (one for each possible
comment). So in short, if I have a comment for item 15, I would like to
automatically insert a row at the end of my first set of data and before my
second set of data that would display the appropriate comment in worksheet A
with out reserving a line for each possible comment

sidenote: if possibel I would like to do this with out employing a user
triggered macro

Sorry for the length of this post and thank you in advance for your time and
effort.