Page Break when a column changes
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!!
|