i have a database of my class and i want to make a repeating student
certificate using excel

is their any way to do this in a simple way ??

> i have a database of my class and i want to make a repeating student
> certificate using excel

I'd use MS-Word's mail merge feature. For details, look in Word's
built-in Help for "mail merge."

Design your form in a separate sheet. In the Cell where the Name goes Use
Data Validation and choose list and reference the range for the names.

You can select the first name and Print off the certificate then select the
second and so on.

This assumes that the data list of names is in the manner you want on the
certificate.

Alternatively, you could use Word to create the certificate and use MAil
Merge to link the Word document to the Excel data list. Once merged you can
print off all the certificates together.

To do the same in Excel youo would have to write a program to do this.

HTH
Peter

"maroo" wrote:

> i have a database of my class and i want to make a repeating student
> certificate using excel
>
> is their any way to do this in a simple way ??
>
>