Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print ALL swimmers certificate
Hi All
I wish to printout certificates for all swimmers participating (50+). On Sheet1 i have Name, Event, Result or time, Position ie 1st, 2nd etc. besides other details. On Sheet2 i have a Cert. template which has fixed details and also variables (currently linked to sheet1 relevant cells) such as swimmer Name, Event, indv Result, Position and also the winner's Name and Result as a comparative. Of course the winner's own certificate will not have the comparative. I can do this manually but to go thru individually is such a time consuming and repeatative and monotonous. Everybody is giving up on the idea. Qn: How do i go about to print all the Certs in one go. I realise i need a macro to loop thru all the names to somehow contact to the template sheet putting in the variable then printout and then go to the next name etc. but my mind is refusing to think; i am newbie on vba though been trying over the few months using J Walk.. book and others especially the web. Using Excel2003 with XP. Your help, ideas and guidance will sincerely help. PS the gala is on 29/30 july. Rgds KZ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need certificate logos | Excel Discussion (Misc queries) | |||
Excel Certificate | Excel Discussion (Misc queries) | |||
Certificate Discarded. | Excel Programming | |||
Digital Certificate | Excel Programming | |||
Digital Certificate | Excel Programming |