View Single Post
 
Old 06-22-2015, 12:14 PM
aldumil aldumil is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Jun 2015
Posts: 4
aldumil is on a distinguished road
Default How to get groups of data on each page

I am having trouble figuring out how to do this. I can't seem to figure it out, and I can't seem to find anything that is quite like it anywhere either.
I have an excel document with people names, addresses and amounts of money. These people are attached to groups that vary in size. They are numbered like:
  • 1 john stamos blah blah info info info
  • 2 jan cool blah blah info info info
  • 3 steve somthing blah blah info info info
  • 1 josh juan blah blah info info info
  • 2 lindsey di blah blah info info info
etc....

The numbers are column A.

What I am trying to do is have a mail merge that executes so that, for example: first page is entries 1,2, and 3. second page is just entries 4 and 5....etc. Continuing down the line somehow separating the groups starting with number 1 for each page and then all rows after it till another number one is reached.
Each entry has to be on the page twice in two different locations.
I know its possible because the person who worked here before me had it all set up to work, however, its been years and the file no longer works. I've tried reverse engineering it to no avail and could really use some pointers.


Thanks to all!
Reply With Quote