Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 243
  • Last Modified:

How to create special formated "print page" from single row of spread sheet

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.

For example:
 - 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.

etc
etc

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!
 
0
lee88
Asked:
lee88
  • 2
1 Solution
 
Aaron TomoskyTechnology ConsultantCommented:
You can mailmerge into word or pull it into access and make a simple report. I don't know how to do this in excel but someone else might.
0
 
Rob HensonIT & Database AssistantCommented:
You could set up a report sheet with the necessary formatting and the data populated by use of a lookup/index formula on the base data.

Cheers
Rob H
0
 
Rob HensonIT & Database AssistantCommented:
See attached basic example.

Cheers
Rob H Report.xls
0
 
lee88Author Commented:
you are a champ! thank you!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now