Need to print formatted text output from Excel to a PDF

[lrutt]

I've already created a form with check boxes to print any / all sheets from my workbook, export the whole workbook as another file, structure file names etc. and it's all working great.

the last item I'm struggling with is formatting and printing a set of meeting notes. I have a sheet that is my meeting index sheet. It contains the meeting index number, meeting date, meeting title, meeting attendees, and meeting notes. this information is all entered via a nice form. Now I need to get this information out in a pdf format. If it was just a sheet that wouldn't be a problem. But it's a set of records on a particular sheet. I'd like the output to look like a normal set of meeting notes:

Meeting Title
Date:
Attendees:
Notes:

The notes themselves contain limited formatting, indents and bullets, that are allowed within cell text.

I've seen articles sending it to word etc. but I'd really like to do it all from Excel and have it put into the same PDF that the rest of the data is sent to.

I've searched for the concept of a output template for Excel but no can find.

Any help would be greatly appreciated.

 

[lrutt]

I kept searching last night and finally found a reference to an old post that solve my problem. Extremely simple actually. Just create another sheet that acts as a template for the formatted output that I want, refer data to that sheet, then print pdf, then clear sheet.

Works great. Just got to find the right word to search for.