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

Posted on 2011-05-11
Last Modified: 2012-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.

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.


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!
Question by:lee88
    LVL 38

    Expert Comment

    by:Aaron Tomosky
    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.
    LVL 31

    Expert Comment

    by:Rob Henson
    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.

    Rob H
    LVL 31

    Accepted Solution

    See attached basic example.

    Rob H Report.xls

    Author Closing Comment

    you are a champ! thank you!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
    My experience with Windows 10 over a one year period and suggestions for smooth operation
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now