Inserting Page breaks based on differnt criteria.... 1

[YNOTU]

Hi all, I have an excel worksheet with a column with a combination of 690 different numbers (some numbers have 30 records, others 200, others 10 etc... I need to know if there's a way to look at this column and add a page brake after each different number.

I'm going to be here all night if I have to do it manually

thanks

​

 

[PHV]

Take a look here: menu Data -> sub total ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[YNOTU]

thank you very very much!!!!!

​