Several questions need to be answered first:
1. Is this a list of existing employees, who periodically change work
locations (hence you are simply editing the location)?

Or
2 Are you adding new employees at the bottom of the list?

3. Is the list sorted (or does it first need to be sorted) on the location
column
so that all workers working a specific location will be first grouped on a
printed page? If not sorted, it seems you would end up with possibly a
separate printed page for each employee? If this is not desired then a sort
would be required after the data entry/edit but before the page break insert.

"ronda" wrote:

I need to write a Macro or VB Script that will insert page breaks above each
row that contains new contents in a particular cell. One column contains the
work location for our employees in code form (i.e. N002), and page breaks
need to be inserted to separate each work location, so there would need to be
a page break at the point that the Work location code changes from N002 to
N003. This is an extremely time-consuming task that has to be performed on
multiple reports every two weeks. Your help is appreciated!!