Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 03-15-2012, 09:37 PM
gsrikanth gsrikanth is offline Is there a way to print based on a particular filter? Windows XP Is there a way to print based on a particular filter? Office XP
Competent Performer
 
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default

Quote:
Originally Posted by Jamal NUMAN View Post
Is there a way to print based on a particular filter?

I wanted to print in separate pages based on a particular filtered value. For example, in the attached file, I need to print according to the name of the governorate such that the “Bethlehem” governorate is never printed in the same page with next governorate, which is “Hebron” in this case.

I’m used to do this sort of work manually (by making empty rows) but wondering if there is an automated way that helps doing so. please, have a look on the attached screenshots.



the data file is attached.


Thank you for the help,

Best

Jamal
use this select first column named list in b2 kept this formula =INDEX(List,MATCH(0,COUNTIF($b$1:b1,List),0)) with ctrl+shift+enter
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Apply filter with VBA bobsawyer7 Outlook 0 03-12-2012 04:02 AM
Is there a way to print based on a particular filter? Mail Merge to print specific record based on mergefield criterias nicnad Mail Merge 1 02-22-2012 01:53 AM
Modify vba code to print based on name in the InputBox OTPM Project 0 05-25-2011 02:03 AM
Is there a way to print based on a particular filter? filter kwlickt Excel 1 03-28-2011 11:15 AM
Is there a way to print based on a particular filter? could you help me help me with advanced filter Nora Excel 1 05-15-2009 11:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:26 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft