Thread: Help with macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gareth gareth is offline
external usenet poster
 
Posts: 37
Default Help with macro

I have files with rows of data (columns A to D) that have
to be printed. The data in column A is in numerical
order. It is possible that some files will have under 100
rows per sheet as well as larger ones with 800+.

If printed as it is the data only takes up half the
portrait page but an awful lot of pages.

What I want to do is use the whole page thus cutting down
the amount of paper by half.

For example:
A B C D
1
2
3
4
5
6
7
8
9
10
....
800

I want it to look like:

Page1
A B C D F G H I
1 63
2 64
3 65
4 66
... ..
62 124

Page2
A B C D F G H I
125 187
126 188
127 189
128 190
129 191
... ..
186 248

etc, etc, etc.

Row 1 is repeated at the top of every sheet and there are
62 rows per sheet.
Any help gratefully received.

Thanks in advance.

Gareth