Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi, I have a huge table which I have to update every week and then insert page breaks after a cahnge on column A
the data looks like this: Author (Title is always at A6) ..... Peter Total 1 Total 2 Jason Total 1 Total 2 Is it possible to create a macro that will insert pagebreaks after any change in column A, after row A6 (so it will exclude the title and info that comes before that), but that it also excludes changes that include the fixed text "total 1" and "total 2"? So it will look: Author Peter Total 1 Total 2 (page break) Jason total 1 Total 2 Thanks for your help!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 Page Break Adjustments causes a page break each cell | Excel Worksheet Functions | |||
How do I insert a page break between every row and column? | Excel Discussion (Misc queries) | |||
insert page break at each change in column B | Excel Programming | |||
Page Break Column Headers | Excel Worksheet Functions | |||
any way to redisplay column headings after page break? | Excel Worksheet Functions |