Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Breaking a long column to print on one sheet
I have two columns of data that I must update and sort alphabetically, then
break the columns to print on one sheet instead of three pages. Is there a way to set this up to print without cutting and pasting to fit on one page? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Breaking a long column to print on one sheet
Your subject saya "a long column" but your description says "two columns".
Which is correct and if two columns how do you want them sorted? Each column independently sorted or? Here is example code to place 2 columns of 200 rows into 8 columns of 50 rows for printing Sub Move_Sets() Dim iSource As Long Dim iTarget As Long iSource = 1 iTarget = 1 Do Cells(iSource, "A").Resize(50, 2).Cut _ Destination:=Cells(iTarget, "A") Cells(iSource + 50, "A").Resize(50, 2).Cut _ Destination:=Cells(iTarget, "C") Cells(iSource + 100, "A").Resize(50, 2).Cut _ Destination:=Cells(iTarget, "E") Cells(iSource + 150, "A").Resize(50, 2).Cut _ Destination:=Cells(iTarget, "G") iSource = iSource + 200 iTarget = iTarget + 51 Loop Until IsEmpty(Cells(iSource, "A").Value) End Sub Gord Dibben MS Excel MVP On Sat, 30 Aug 2008 12:03:01 -0700, Pathwalker wrote: I have two columns of data that I must update and sort alphabetically, then break the columns to print on one sheet instead of three pages. Is there a way to set this up to print without cutting and pasting to fit on one page? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print a long 2 page column list, on one page | Excel Discussion (Misc queries) | |||
Print all tabs to pdf when some have been added w/o breaking file | Excel Discussion (Misc queries) | |||
How to get a long column of numbers to wrap and print on 1 page? | Excel Discussion (Misc queries) | |||
how do you keep fields in a column to print out for long list | Setting up and Configuration of Excel | |||
Non-Breaking Space + Print Issue | Charts and Charting in Excel |