Topic: Excel ruptures of pages on a condition
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!