#1
|
|||
|
|||
Is there a way to print based on a particular filter?
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
__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank. |
#2
|
|||
|
|||
Quote:
|
#3
|
|||
|
|||
Quote:
thank you for the answer gsrikanth. i tried what you have already advised but sounds not to work with me. I'm not sure if your time permits to stick the equation on my actual excel sheet (which is provided in my previous post) so that i can proceed. all the best Jamal
__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank. |
#4
|
|||
|
|||
You can place a page break when the cell value in column 1 changes.
Code:
Option Explicit Sub MakePageBreaks() Dim i As Integer ActiveSheet.ResetAllPageBreaks Application.ScreenUpdating = False For i = 2 To 800 If ActiveSheet.Cells(i, 1).Text <> ActiveSheet.Cells(i + 1, 1).Text Then ActiveSheet.Cells(i + 1, 1).Select ActiveWindow.SelectedSheets.HPageBreaks.Add before:=ActiveCell End If Next Application.ScreenUpdating = True End Sub |
#5
|
|||
|
|||
Quote:
Perfect… this is what I’m looking for exactly. Many thanks Catalin.B. your time and efforts are highly appreciated. Best Jamal
__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Apply filter with VBA | bobsawyer7 | Outlook | 0 | 03-12-2012 04:02 AM |
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 |
filter | kwlickt | Excel | 1 | 03-28-2011 11:15 AM |
could you help me help me with advanced filter | Nora | Excel | 1 | 05-15-2009 11:10 AM |