You could insert a new worksheet and, on that, insert a formula like:
=OFFSET(Sheet1!$A$1,(COLUMN()-1)*50+ROW()-1,)
where '50' is the number of rows you want to use on that worksheet. Simply copy the formula down to your last row (50 in the example), then across as far as needed.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|