Here is a google sheet with the layout information we like to use.
[login to view URL]
Please advise if you can prepare the function using Google Script.
The PDF will be created using the Gray Range - print selected range - to fit on page.
THen save PDF if Google Drive using the name provided on the sheet.
Like to use Google Script because function will be included in a larger configuration.
We need the function to use named ranges to define the area of the spread sheet to be printed, because the areas will change depending on the case.
The area to be printed needs to be defined by the opposite corners (named ranges).
Print Gray Range, but the range is defined by the the two range variables that are passed along to the function.
some times we need to print more lines, and some time less lines.
We can define the upper and lower corner using Named Ranges to define the area to be printed.
THe File name will be a cell that will be updated with the correct file name every time the function is called to print.
The function should be called from the button on the sheet. (Click Button to Create -PDF- File).
Put "Don't worry" in your bid