Hi All, I have a real head-scratcher here. I have a workbook that is being used for document training courses. In it, there are two worksheets: The Data worksheet contains the location of training, trainer, trainee and course data. It is formatted to "look nice". The Summary worksheet contains a summary of the Data worksheet, and is formatted to be more useful for import into a database or other workbook for future analysis or evaluation. The problem is, that the trainer can train as many as 3 different course (or in this case, "Applications) to the trainees. In order to keep data entry as simple as possible for the trainers, the trainee demographic information appears only once but the courses can appear once, twice or three times. In the summary worksheet, I need to have the trainee demographic information appear as many times as the trainee courses appear. You can see a picture of what it is I am trying to do here. It's easier to see than describe...
I appreciate any help. Thank in advance...
I appreciate any help. Thank in advance...
