+ Reply to Thread
Results 1 to 4 of 4

Print sheets based on content in a column

  1. #1
    Registered User
    Join Date
    05-31-2013
    Location
    Bergen, Norway
    MS-Off Ver
    Excel 2010
    Posts
    3

    Print sheets based on content in a column

    I need help printing sheets based on content in a column.

    This is a list of stock where I need to "pagebreak" between the categories in column D, so that I get "clean" lists of each category.
    These lists can be quite long, so doing this manually takes too long, and "filtering and printing" is also quite ineffective.

    "Column D" can be printed as the "column A" if necessary.

    Appreciate any help I can get!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    12-28-2014
    Location
    NSW, Australia
    MS-Off Ver
    MS365
    Posts
    606

    Re: Print sheets based on content in a column

    Hi whoknows, the easiest way would be to click on Data, then Subtotal, Select Produktprisgr. 1, tick "Page break between groups" and click ok.

  3. #3
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Print sheets based on content in a column

    One quick way to do this...

    Go to Data Tab> Subtotals>

    At Each Change in "Produktprisgr. 1"
    Use Function Count (unless there's a column you'd like to sum or average)
    Add Subtotal to "Produktprisgr. 1" (unless there's a column you'd like to sum or average)
    Check "Replace current subtotals" and "Page break between groups"
    Uncheck "Summary below data"
    OK
    Does that work for you?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  4. #4
    Registered User
    Join Date
    05-31-2013
    Location
    Bergen, Norway
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Print sheets based on content in a column

    Ahhh, fantastic - thanks alot!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Create new sheets which split data according to Column (A) content
    By Tmc2159 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-10-2013, 11:55 AM
  2. Split Rows into Sheets Based on Content
    By djbeadle in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-31-2012, 02:22 AM
  3. VBA to select print area based on content in cells
    By Kevlo79 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-03-2012, 07:25 PM
  4. Replies: 5
    Last Post: 10-26-2011, 11:57 AM
  5. How to delete all content in a row based on a column's content
    By mccalljohn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2011, 12:05 AM
  6. conditional transfer of rows to other sheets based on cell content of 2 colums
    By ashncg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2011, 12:22 PM
  7. adding values of a column based on another column content
    By gideong in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-16-2009, 11:53 AM
  8. Linking Information in Sheets based on its content
    By Laura in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-30-2005, 11:55 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1