How to??

%3CLINGO-SUB%20id%3D%22lingo-sub-2502867%22%20slang%3D%22en-US%22%3EHow%20to%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2502867%22%20slang%3D%22en-US%22%3E%3CP%3EI%20Need%20help%20creating%20a%20data%20page%20that%20will%20let%20me%20select%20a%20group%20of%20serial%20numbers%20that%20will%20print%20on%20a%20monthly%20log.%3C%2FP%3E%3CP%3EFor%20Example%20I%20have%2020%20pieces%20of%20equipment%20That%20need%20monthly%20logs%20for%20different%20Programs.%3C%2FP%3E%3CP%3EI%20want%20to%20open%20the%20Excel%20Document%2C%20enter%20program%20name%20and%20new%20month%20and%20print%20each%20log%20with%20the%20individual%20serial%20number%20and%20different%20program%20areas.%20The%20Log%20has%20already%20been%20made%2C%20I%20just%20need%20to%20know%20how%20to%20get%20the%20data%20to%20insert%20into%20the%20document%20and%20print%20each%20page%20with%20each%20serial%20number.%20Like%20printing%20a%20set%20of%20logs.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-06-30%20121947.png%22%20style%3D%22width%3A%20883px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F292664i95E5D8045973C7DA%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-06-30%20121947.png%22%20alt%3D%22Screenshot%202021-06-30%20121947.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2502867%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2513888%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2513888%22%20slang%3D%22en-US%22%3Ebesides%20showing%20the%20form%20where%20the%20data%20need%20to%20be%20inserted%2C%20you%20also%20need%20to%20show%20the%20dataset%20or%20a%20sample%20of%20it%20in%20order%20to%20formulate%20a%20solution%20for%20example%3A%3CBR%20%2F%3E1%2Ba%3CBR%20%2F%3Eyou%20showed%20one%20value%20but%20we%20don't%20know%20the%20value%20of%20a%20(your%20dataset)%3CBR%20%2F%3E%3CBR%20%2F%3Echeers%3C%2FLINGO-BODY%3E
Occasional Visitor

I Need help creating a data page that will let me select a group of serial numbers that will print on a monthly log.

For Example I have 20 pieces of equipment That need monthly logs for different Programs.

I want to open the Excel Document, enter program name and new month and print each log with the individual serial number and different program areas. The Log has already been made, I just need to know how to get the data to insert into the document and print each page with each serial number. Like printing a set of logs. 

 Screenshot 2021-06-30 121947.png

1 Reply

besides showing the form where the data need to be inserted, you also need to show the dataset or a sample of it in order to formulate a solution for example:
1+a
you showed one value but we don't know the value of "a"  (which is your dataset)

cheers