Format side by side

[Garyd]

I am working on a project for a user that is requesting
something a little different. What they want to do is out
of a list of 1000 rows they want to see only 40. The
trick part is they want to see twenty on one side of the
worksheet and twenty on the second part of the worksheet
which means side by side. Is this possible and can it be
automatied.

 

[Gord Dibben]

Yes, it is possible to automate selection of 40 rows and copy to another sheet
where they could be split to two sections of 20 each.

I assume the data will fit on one sheet when split to two. You say "rows" but
may mean a column or few columns of each row?

Also, what determines the 40 rows to be used?

Gord Dibben Excel MVP