Insert pagebreak in row where a value matches value in A1

karissao

New Member
Joined
Feb 5, 2010
Messages
8
I have a book with many sheets. In each sheet the case is the same. I have a value in A1, which will be found in 1 other A cell in unknown row. I want to insert a page break in the matching row. Let's say A1 value is: F342, I want to find the other F342, which happens to be (this time) in A349. Then I want to insert a page break in row 349. I would love to loop through my sheets as well, but not the 2 sheets named "Stops1" and "Stops1 Summary"

Please help.
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Watch MrExcel Video

Forum statistics

Threads
1,118,407
Messages
5,571,924
Members
412,426
Latest member
DeficientOptimism
Top