how do i create a repeating student certificate using excel
in [Functions]
|
Prev: How do i set up a concecutive numbers in Microsoft excel sheet?
Next: Excel 2003 make 1 date cell automatically change another date cell
From: maroo on 21 Apr 2010 19:28 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 ??
From: zvkmpw on 21 Apr 2010 20:17 > 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."
From: Billy Liddel on 21 Apr 2010 20:56
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 ?? > > |