• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Print Range

N

niting

New Member
Hie forum,


I have data with sl no. name and address and other details. The name and address extends to 3-4 rows for a serial number.


Is there a formula/shortcut wherein I can specify that per sheet only 11 serial numbers should be printed??? I have the data running into 2000 Serial numbers and specifying the print range manually is a task.


Thanks

Nitin
 
On the same topic above, I thought I might identify the 11th serial number and then set print range at that point. so i tried CF in the serial number column with the rule as follows-:


=MOD(A4,11)=0


HOwever, it also highlights the rows which are empty.


So stuck royally. ANy help???


Thanks
 
You must log in or register to reply here.
Back
Top