I updated my example, to give you easiest and error-free way to manually add missing ID's to user comments table.
Added is a sheet AgeGroups, where all possible age groups are defined (EndAge is defined for age group ">64800" too, simply it must be big enough - because this makes filtering the Report easier. And there is additionally an AgeGroup "All" defined, which allows to display in Report all data from Data sheet. The column AgeGroup contains group ID, and you are free to edit it in any way so long the value remains unique;
Added is a sheet Comments, where user(s) can enter the info about progress and feedback for any ID. User can enter missing ID's manually directly here, but there is a way to do this in bulk using Report Sheet now;
On Report sheet, now instead of entering Start and End Ages, you select (there is a Data Validation List defined) the Age Group (nStartAge and nEndAge for selected AgeGroup are calculated - check Name Manager to see how);
On Report Sheet, Progress and Feedback are read from Comments sheet, when there exists an ID in this row. When not, those cells remain empty. When ID exists in Report sheet, but doesn't exist in Comment sheet, a message (currently the message is "ID missing!", but you can change it) is displayed;
Now, when you set the Age Group for Report to "All", and Autofilter for either Progress or Feedback column to missed ID message text (currently "ID missing!"), you get a list of all data which don't have ID registered on Comments sheet. Copy listed ID's, and use PasteSpecial.Values (NB! You have to paste values, not formulas!) to paste all missing ID's into ID column of Comments table. Now clear the Autofilter (and set AgeGroup when you don't want all data displayed). And you (or anyone) can now enter Progress/Feedback info for added ID's in Comments sheet.
Edit: Btw, age 10079 falls out of age ranges you did declare in post #8!
|