Making custom forms

%3CLINGO-SUB%20id%3D%22lingo-sub-1114028%22%20slang%3D%22en-US%22%3EMaking%20custom%20forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1114028%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20create%20a%20table%20with%20certain%20customer%20info%20and%20I%20want%20it%20to%20be%20populated%20using%20a%20form.%20Then%2C%20I%20want%20to%20be%20able%20to%20select%20a%20record%20and%20have%20the%20info%20print%20on%20a%20form%20format%20I%20have.%20Attached%20is%20what%20I%20have%20so%20far.%20Sheet%20%22Data%22%20has%20the%20fields%20I%20need%20to%20populate.%20Sheet%20%22Print%22%20is%20the%20form%20where%20I'll%20want%20the%20info%20in%20%22Data%22%20to%20print.%26nbsp%3B%20That's%20all%20I%20have%20so%20far.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20point%20me%20in%20the%20right%20direction%20to%20complete%20this%20worksheet%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1114028%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

I want to create a table with certain customer info and I want it to be populated using a form. Then, I want to be able to select a record and have the info print on a form format I have. Attached is what I have so far. Sheet "Data" has the fields I need to populate. Sheet "Print" is the form where I'll want the info in "Data" to print.  That's all I have so far.

 

Can anyone point me in the right direction to complete this worksheet?

1 Reply
Highlighted

@Ed-Rivera 

 

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