copy only the 1st, 7th, 13th, 19th, 25th.....row only
tnks
It helps to solve my problem.
"RagDyer" wrote:
Enter this formula *anywhere*,
=INDEX($A:$A,COLUMNS($A:A)+6*ROWS($1:1)-6)
Then copy across 6 columns,
Then copy down as many rows as needed.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"vcff" wrote in message
...
I have information in col A. Every six rows (A1:A6, A7:A12.) belongs to the
item.
As it was not an easy way to view the informations, I intended to move the
informations across the columns,
B1=A1, C1=A2, D1=A3, E1=A4........
B2=A7, C2=A8, D2=A9..
B3=A13, C3=A14..
tnks
|