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

Currently I am reserving lines for each possible comment and then running a macro that detects / deletes blank lines but I want to eliminate the macro step to help reduce user errors

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