A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

how do i create a repeating student certificate using excel



 
 
Thread Tools Display Modes
  #1  
Old April 22nd, 2010, 12:28 AM posted to microsoft.public.excel.worksheet.functions
maroo
external usenet poster
 
Posts: 1
Default how do i create a repeating student certificate using excel

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 ??


  #2  
Old April 22nd, 2010, 01:17 AM posted to microsoft.public.excel.worksheet.functions
zvkmpw
external usenet poster
 
Posts: 50
Default how do i create a repeating student certificate using excel

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."
  #3  
Old April 22nd, 2010, 01:56 AM posted to microsoft.public.excel.worksheet.functions
Billy Liddel
external usenet poster
 
Posts: 489
Default how do i create a repeating student certificate using excel

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 ??


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:23 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.