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!
Hi whoknows, the easiest way would be to click on Data, then Subtotal, Select Produktprisgr. 1, tick "Page break between groups" and click ok.
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
Ahhh, fantastic - thanks alot!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks