Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |