Forum Discussion
Making custom forms
You describe two sheets in your posting, but there are three in the workbook. So it was a little difficult following how this might work. I definitely see the final certificate, which I presume is what you're trying to fill in.
One suggestion that I might make--assuming you're relatively comfortable (as it appears) with Excel. You'll need to put column headings on the two database sheets. I saw you'd used VLOOKUP for one of the areas in your certificate for printing. But I assume you're wanting to fill other fields on that form, based on some kind of input.
So VLOOKUP is one way to proceed.
Another set of functions you might consider are the various database functions, those beginning with the letter D. DGET in particular is one that I've used in some similar situations. Do some research on that and see if it would help. And of course come back with further questions....