Page break macro

  • Thread starter Thread starter lehigh46
  • Start date Start date
L

lehigh46

Hi All:

We are going to export an Excel employee report from our accounting
program. The report will have an emplyee number and three rows of text
pertaining to that employee, then another employee number and three
more rows of text, and so on.

We have the need to print only the four rows of each record and
include it with the employees pay check.

How should that portion of macro be written so it will insert a page
break between each set of records.

Thanks for any help you can give me.

Tom Snyder
 
I don't think I understand your answer.
Do you mean Help in Excel?

Also, I forgot to mention that we could have as many as 500 employees

Thanks again

Tom Snyder
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - counting cells by colors and names to it in two different rows. 0
Lookup Formula 4
Drill down via page fields 1
Searching data in multiple rows using search criteria 2
Excel Worksheet Functions 5
Excel Facetime Measurement 1
Counting rows that meet multiple criteria 5
monthly consolidation in separate worksheet 1

Back
Top