Print Multiple Record-Data as Pdf File in 2 Sheets

[Jhon Mustofa]

hi all...

i have 2 sheet, input and output...
my target in yellow area..
i want how to make print multiple record/data based at once on field with sheet "input" as data and sheet "Ouput' as report...
result print as pdf file using Macro/VBA

attachment file...

any help is greatly appreciated...

john m

[sauerj]

I think I understand what you want, but just checking. You want a macro that would save multiple PDF files (one for each row in the 'input' sheet).
There are 159 rows in the 'input' sheet, as the file stands now. So, when the macro was done, there would be 159 PDF files based on the 'output' sheet form,
with the yellow highlighted cells filled in with each 'input' sheet's row's 6 cells. You didn't specify a yellow cell for the location, but I assume it is the cell just
below the Date cell (the cell that lines up with the row with a header labeled: 'Luas' ... correct?).
Do I have your intention correct?
If so, then what file name structure would you like to use for naming these 159 PDF files?