i have to print an excel file which lends itself to to splitting in to
two halves and moving the bottom have to an adjacent colum and at the
same start row

my spread sheet is 3 colums wide and can be 200 to 2000 rows long.
granted i could physically take the no of rows and devide into two and
drag to the top of the table. this dose ot work when yo pass a
programme on.

all and any help apppreciated


---
Message posted from http://www.ExcelForum.com/

There is no magic here. To print side by side, you need to physically
create a sheet that has the data located side by side. You can either copy
it manually or do it with formulas, or use a macro. What type of help are
you looking for?

--
Regards,
Tom Ogilvy

"alexanderd " wrote in message
...
i have to print an excel file which lends itself to to splitting in to
two halves and moving the bottom have to an adjacent colum and at the
same start row

my spread sheet is 3 colums wide and can be 200 to 2000 rows long.
granted i could physically take the no of rows and devide into two and
drag to the top of the table. this dose ot work when yo pass a
programme on.

all and any help apppreciated


---
Message posted from http://www.ExcelForum.com/