How to create special formated "print page" from single row of spread sheet
Posted on 2011-05-11
I have a source spreadsheet in Excel 2010 that has about 80 lines.
Each line has 11 columns.
I'd like to create (a macro?) an ability to print the contents of a user-specified line of the source spreadsheet to a 8-1/2" x 5-1/2" (1/2 of a 8-1/2 x 11) print-page format. Each cell from the user-specified source line would appear in a unique fixed position on the output sheet, with unique formatting. All source-sheet cells are text. No Numeric data.
- the "C" column of the source spreadsheet contains the "title" text. I'd like that text to be "fit" across the top of the output page, as large as possible without wrapping to multiple lines.
- the "K" column contains (typically) several lines of text which are comments. I'd like that text to be dumped into the lower-left quarter of the output page, and either truncated if it doesn't fit (with wrapping), or fit to that quarter-page space.
My appliaction is a low-quantity work-flow need. Source spreadsheet only has 80 rows now. May grow to 200 or so rows. Will use this new custom-print-it app dozens of times per month to print specific rows as half-sheets.
What is the best excel-coding approach for me to do this?
Any example-code for the two above examples would be greatly appreciated. Thanks!