LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro recorded... tabs & file names changed, macro hangs Steve Excel Worksheet Functions 3 October 30th 09 11:41 AM
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort Gavin Excel Worksheet Functions 0 May 17th 07 01:20 PM
how to count/sum by function/macro to get the number of record to do copy/paste in macro tango Excel Programming 1 October 15th 04 01:16 PM
macro to delete entire rows when column A is blank ...a quick macro vikram Excel Programming 4 May 3rd 04 08:45 PM
Start Macro / Stop Macro / Restart Macro Pete[_13_] Excel Programming 2 November 21st 03 05:04 PM


All times are GMT +1. The time now is 10:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"