I've had help from users on this forum ion the past in connection with this topic
http://www.vbaexpress.com/forum/show...th-same-Ref-No
My query is in connection with that topic.
I would like to know if we were to merge the whole data file into the template at once, is there an automatic way to then split/page break each time the POLLING_DISTRICT changes. For example, the first 100 or so entries could all be POLLING_DISTRICT value AA01, then the next POLLING_DISTRICT value is AA02 etc. Then force AA02 entries to start on a new page.
Or automatically split/save each POLLING_DISTRICT as a new file and automatically giving it the filename of the POLLING_DISTRICT value?
Hope this makes sense.
Thanks