Fill a template with excel data

[aruna]

Hi All,

I need to pick up a record from an excel sheet based on a serial number and complete another sheet which has a text template laid out on it with values at the appropriate places.

This is with the idea that the first sheet acts as a database and the second sheet, a certificate , can be generated on the fly for any given record.

I tried insert merge field which kind of worked but not to my satisfaction. Is there any other way to do this. I am a developer but a newbie to rich features of excel..VB codes/macros are welcome too!

Please help!

 

[Trevor G]

Welcome to the Forum,

Is the template a word document if so then you can set bookmarks into the document and get the data to be copied to the appropriate bookmark

In word you can record a macro to find the bookmark by using the GoTo command (Which is F5) then select the bookmark by name and click goto, then stop recording and then you can look at the code, and adapt it to work from Excel.

If it is just another Excel Sheet acting as the certificate then look to use a Vlookup formula.