1

Topic: Excel ruptures of pages on a condition

Good afternoon!
Help please with a macro.
There is a table with the goods their data on them (the attached file see). In column B commodity groups, and in a column From the street price decision are specified. On the press it is necessary to be adjusted this report so that in commodity group it was not formed rupture of pages.
For example, at line 239 there is a rupture in commodity group, it is necessary for lifting till 237 lines so that the new sheet began with line SHORTS Denim ovr. An amount of lines in each commodity group a miscellaneous, there can be blank lines.
Thankful in advance!

2

Re: Excel ruptures of pages on a condition

4omp wrote:

  in commodity group it was not formed rupture of pages.

And if 2-3 groups get on 1 page

3

Re: Excel ruptures of pages on a condition

Here procedure reengines of ruptures of pages long understood
[url =] http://www.sql.ru/forum/352174/razryvy-stranic-v-excel [/url]