Copy lines from sheet 2 to sheet 6
On Sheet6, enter this in B1:
=Sheet2!I1
And in B2 enter this:
=INDEX(Sheet2!I:I,7*ROWS($1:1))
and copy down as needed.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"pcor" wrote in message
...
I have some data in sheet 2 in col I.
the data I want to capture is spaced by 7 spaces all the ay down:
EX:
I have data in sheet 2 col I row 1 ,7,14,21 etc
I would like to show the data in Sheet 2 to Sheet 6 col B row 1,2,3,4, etc
thanks
|