Thread: [Solved] Macro Loop Help
View Single Post
 
Old 09-16-2015, 09:09 AM
Twizzle008 Twizzle008 is offline Windows 7 32bit Office 2010 64bit
Novice
 
Join Date: Sep 2015
Posts: 6
Twizzle008 is on a distinguished road
Default

Ah I see what you mean.

The issue i have now then is the employee number appears twice on one payslip. But the Pub name appears at the end of the payslip which is where i would like to implement a page break. The only issue is then the Payslip which starts on the next with the employee number is now halfway down the page.

The payslip starts with an employee number at the top left of the page,

If there was a way of say looking for pub "The Green Man", then putting in a page break, then looking for the next employee number after the pub name ie "1234567" and then pulling the data from the employee number onwards to the top of that page? So that the Next payslip thn starts at the top of the pageHopefully this makes sense.

Many thanks
Reply With Quote