Filter data to multiple pages

[YasserKhalil]

Hello everyone
I have Data sheet and I need to filter data according to Target column (Column A) .. and each category to be in separate page (not sheets)
The results should be in Result sheet in multiple page as illustrated in the attachment
Thanks advaced for help

[JLGWhiz]

Why not just set page breaks between the groups? They would then print out on separate pages.

[YasserKhalil]

Thanks for reply
But I need to do that task using code ..and I can't use page breaks in vba

[YasserKhalil]

Is it possible to know the row number for page breaks .so we can depend on it in putting the results of filtered data?

[YasserKhalil]

Ok forget the thread and tell me how to know the rows for page breaks in used range>>
I found this piece of code but it brings only the first page break

Please Login or Register  to view this content.

And this is another code but I got an error '9' subscript out of range

Please Login or Register  to view this content.

at this line the error occurred

Please Login or Register  to view this content.

[JLGWhiz]

This would clear any existing page breaks and set new ones based on column a data being sorted by Target.

Please Login or Register  to view this content.

[rukman]

I will send you tommorow

[YasserKhalil]

Thanks for help
I don't need to insert page breaks .. I need to know the rows for page breaks ..

[JLGWhiz]

This will show you where they are:

Please Login or Register  to view this content.

[YasserKhalil]

This will show you where they are:

Please Login or Register  to view this content.

Thanks for reply but this is not what I need ..
Need to extract rows' numbers at pagebreaks

[JLGWhiz]

Thanks for reply but this is not what I need ..
Need to extract rows' numbers at pagebreaks

Sorry, that's all I have to offer. Suggest you use the VBA help files or web search to get additional information on page breaks. They can be troublesome, depending on your sheet structure in terms of row heights and column witdths. The page breaks are calculated by Excel based on anticipated printer output. So automatic page breaks can change randomly if changes occur to rows and columns. Manual page breaks also present problems if changes occur in the worksheet after initial settings. Good luck. Regards, JLG

[rukman]

please small look on this... if you need that data to be separated to new, new pages... ok i understand.... if the page column length (eg:- 20 rows). If we code to 1 sheet 1st data filtered. 2nd page 2nd data filtered.... now that row exited to 20 that codes not working... so send one pay slip copy. check that. its ok implement from that model

[YasserKhalil]

Thank you very much JLG for sharing the thread ..and for the information provided in your posts about the issue
Thanks a lot Mr. Rukman for the model .. it would be very useful in some of my cases
Hope to find an easy way to achieve that task to have the page breaks calculated automatically on anticipated printer output..