Hi

I'm currently working on a project that consists of filing data of lecture attendance. Now what we have, is an exel chart of all the people who have attended any of the lectures, where, when, how long was the lecture and which one was it. Now what I need to do, is create a macro that will take the data from one line [Name, company, lecture, date & time, length], and create a certificate that uses the data that the particular line has.

The said list contains roughly about 100 names at this point, and I think that manual typing one by one would be a pain. So I was hoping that someone could tell me how I can get exel to repeat the project for each line, untill it finds a line that doesn't have data on it. Also, does anyone know if I can create a macro that takes data from exel, and places it into a word file in the spesific places I want it to be placed, and can it be created as a self repeating process

Thank you in advance for everyone who replys to this thread
I'd also like to apologize for my poor grammar, but I'm not a native speaker of English

- Jere