View Single Post
  #1   Report Post  
jaimeA jaimeA is offline
Junior Member
 
Posts: 3
Default 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!!