ExcelBanter - Excel Certificate

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel Certificate (https://www.excelbanter.com/excel-discussion-misc-queries/133722-excel-certificate.html)

gloria81101

Excel Certificate

I have created a certificate in Excel (which would be under sheet 1) and have
all the names listed in sheet 2 that I need a certificate for. How do I
create a formula or macro that will insert each individual name automatically
when I print?

Gord Dibben

Excel Certificate

A start could be having a look here at John Walkenbach's site.

http://www.j-walk.com/ss/excel/tips/tip92.htm

Downloadable workbook with code for mailmerge using Excel only.

Gord Dibben MS Excel MVP

On Wed, 7 Mar 2007 07:17:16 -0800, gloria81101
wrote:

I have created a certificate in Excel (which would be under sheet 1) and have
all the names listed in sheet 2 that I need a certificate for. How do I
create a formula or macro that will insert each individual name automatically
when I print?

All times are GMT +1. The time now is 02:37 PM.