Printing 1 table into 2

[JTL9161]

I have a 12 column 130 line table. I want to print half of the table (65 lines) on the left side of the sheet and then print the 2nd (12 column/65 lines) next to it on the right side of the sheet.

Thank you for your assistance.


James

 

[Jeffrey Mahoney]

How about this method. You can keep your main table in tact with all the rows. On another sheet you can split them in half

Book2
	A	B	C	D	E	F	G	H	I	J	K	L
1	Col 1	Col 2	Col 3	Col 4	Col 5	Col 6	Col 7	Col 8	Col 9	Col 10	Col 11	Col 12
2	Row01 Col01	Row01 Col02	Row01 Col03	Row01 Col04	Row01 Col05	Row01 Col06	Row01 Col07	Row01 Col08	Row01 Col09	Row01 Col10	Row01 Col11	Row01 Col12
3	Row02 Col01	Row02 Col02	Row02 Col03	Row02 Col04	Row02 Col05	Row02 Col06	Row02 Col07	Row02 Col08	Row02 Col09	Row02 Col10	Row02 Col11	Row02 Col12
4	Row03 Col01	Row03 Col02	Row03 Col03	Row03 Col04	Row03 Col05	Row03 Col06	Row03 Col07	Row03 Col08	Row03 Col09	Row03 Col10	Row03 Col11	Row03 Col12
5	Row04 Col01	Row04 Col02	Row04 Col03	Row04 Col04	Row04 Col05	Row04 Col06	Row04 Col07	Row04 Col08	Row04 Col09	Row04 Col10	Row04 Col11	Row04 Col12
6	Row05 Col01	Row05 Col02	Row05 Col03	Row05 Col04	Row05 Col05	Row05 Col06	Row05 Col07	Row05 Col08	Row05 Col09	Row05 Col10	Row05 Col11	Row05 Col12
7	Row06 Col01	Row06 Col02	Row06 Col03	Row06 Col04	Row06 Col05	Row06 Col06	Row06 Col07	Row06 Col08	Row06 Col09	Row06 Col10	Row06 Col11	Row06 Col12
8	Row07 Col01	Row07 Col02	Row07 Col03	Row07 Col04	Row07 Col05	Row07 Col06	Row07 Col07	Row07 Col08	Row07 Col09	Row07 Col10	Row07 Col11	Row07 Col12
9	Row08 Col01	Row08 Col02	Row08 Col03	Row08 Col04	Row08 Col05	Row08 Col06	Row08 Col07	Row08 Col08	Row08 Col09	Row08 Col10	Row08 Col11	Row08 Col12
10	Row09 Col01	Row09 Col02	Row09 Col03	Row09 Col04	Row09 Col05	Row09 Col06	Row09 Col07	Row09 Col08	Row09 Col09	Row09 Col10	Row09 Col11	Row09 Col12
11	Row10 Col01	Row10 Col02	Row10 Col03	Row10 Col04	Row10 Col05	Row10 Col06	Row10 Col07	Row10 Col08	Row10 Col09	Row10 Col10	Row10 Col11	Row10 Col12
12	Row11 Col01	Row11 Col02	Row11 Col03	Row11 Col04	Row11 Col05	Row11 Col06	Row11 Col07	Row11 Col08	Row11 Col09	Row11 Col10	Row11 Col11	Row11 Col12
13	Row12 Col01	Row12 Col02	Row12 Col03	Row12 Col04	Row12 Col05	Row12 Col06	Row12 Col07	Row12 Col08	Row12 Col09	Row12 Col10	Row12 Col11	Row12 Col12
14	Row13 Col01	Row13 Col02	Row13 Col03	Row13 Col04	Row13 Col05	Row13 Col06	Row13 Col07	Row13 Col08	Row13 Col09	Row13 Col10	Row13 Col11	Row13 Col12
Table

Cell Formulas
Range	Formula
A2:L14	A2	="Row"&TEXT(ROW()-ROW($A$1),"00")&" Col"&TEXT(COLUMN(),"00")

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
1	Col 1	Col 2	Col 3	Col 4	Col 5	Col 6	Col 7	Col 8	Col 9	Col 10	Col 11	Col 12		Col 1	Col 2	Col 3	Col 4	Col 5	Col 6	Col 7	Col 8	Col 9	Col 10	Col 11	Col 12
2	Row01 Col01	Row01 Col02	Row01 Col03	Row01 Col04	Row01 Col05	Row01 Col06	Row01 Col07	Row01 Col08	Row01 Col09	Row01 Col10	Row01 Col11	Row01 Col12		Row66 Col01	Row66 Col02	Row66 Col03	Row66 Col04	Row66 Col05	Row66 Col06	Row66 Col07	Row66 Col08	Row66 Col09	Row66 Col10	Row66 Col11	Row66 Col12
3	Row02 Col01	Row02 Col02	Row02 Col03	Row02 Col04	Row02 Col05	Row02 Col06	Row02 Col07	Row02 Col08	Row02 Col09	Row02 Col10	Row02 Col11	Row02 Col12		Row67 Col01	Row67 Col02	Row67 Col03	Row67 Col04	Row67 Col05	Row67 Col06	Row67 Col07	Row67 Col08	Row67 Col09	Row67 Col10	Row67 Col11	Row67 Col12
4	Row03 Col01	Row03 Col02	Row03 Col03	Row03 Col04	Row03 Col05	Row03 Col06	Row03 Col07	Row03 Col08	Row03 Col09	Row03 Col10	Row03 Col11	Row03 Col12		Row68 Col01	Row68 Col02	Row68 Col03	Row68 Col04	Row68 Col05	Row68 Col06	Row68 Col07	Row68 Col08	Row68 Col09	Row68 Col10	Row68 Col11	Row68 Col12
5	Row04 Col01	Row04 Col02	Row04 Col03	Row04 Col04	Row04 Col05	Row04 Col06	Row04 Col07	Row04 Col08	Row04 Col09	Row04 Col10	Row04 Col11	Row04 Col12		Row69 Col01	Row69 Col02	Row69 Col03	Row69 Col04	Row69 Col05	Row69 Col06	Row69 Col07	Row69 Col08	Row69 Col09	Row69 Col10	Row69 Col11	Row69 Col12
6	Row05 Col01	Row05 Col02	Row05 Col03	Row05 Col04	Row05 Col05	Row05 Col06	Row05 Col07	Row05 Col08	Row05 Col09	Row05 Col10	Row05 Col11	Row05 Col12		Row70 Col01	Row70 Col02	Row70 Col03	Row70 Col04	Row70 Col05	Row70 Col06	Row70 Col07	Row70 Col08	Row70 Col09	Row70 Col10	Row70 Col11	Row70 Col12
7	Row06 Col01	Row06 Col02	Row06 Col03	Row06 Col04	Row06 Col05	Row06 Col06	Row06 Col07	Row06 Col08	Row06 Col09	Row06 Col10	Row06 Col11	Row06 Col12		Row71 Col01	Row71 Col02	Row71 Col03	Row71 Col04	Row71 Col05	Row71 Col06	Row71 Col07	Row71 Col08	Row71 Col09	Row71 Col10	Row71 Col11	Row71 Col12
8	Row07 Col01	Row07 Col02	Row07 Col03	Row07 Col04	Row07 Col05	Row07 Col06	Row07 Col07	Row07 Col08	Row07 Col09	Row07 Col10	Row07 Col11	Row07 Col12		Row72 Col01	Row72 Col02	Row72 Col03	Row72 Col04	Row72 Col05	Row72 Col06	Row72 Col07	Row72 Col08	Row72 Col09	Row72 Col10	Row72 Col11	Row72 Col12
9	Row08 Col01	Row08 Col02	Row08 Col03	Row08 Col04	Row08 Col05	Row08 Col06	Row08 Col07	Row08 Col08	Row08 Col09	Row08 Col10	Row08 Col11	Row08 Col12		Row73 Col01	Row73 Col02	Row73 Col03	Row73 Col04	Row73 Col05	Row73 Col06	Row73 Col07	Row73 Col08	Row73 Col09	Row73 Col10	Row73 Col11	Row73 Col12
2 Tables

Cell Formulas
Range	Formula
A2:L66	A2	=TAKE(Table!$A$2:$L$131,ROWS(Table!$A$2:$L$131)/2)
N2:Y66	N2	=TAKE(Table!$A$2:$L$131,-(ROWS(Table!$A$2:$L$131)/2))
Dynamic array formulas.