I don't understand your meaning of <<< "merges" rows 1 and 2

The formula will perform *exactly* as you wish, with *no* revisions
necessary!

Copy and paste the formula into T2,
Then, click on the "fill handle" and drag down to copy to T42.


--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"ked" wrote in message
...
Hi RD -

When I enter the INDEX formula it merges rows 1 & 2 in my "ALL" document.

If I want all the info in row 6, columns b thru aq to *index* over to my
"ALL" document in Column T rows, 2 thru 42, how would I adjust your
formula?


I guess I'm a little confused on this. Sorry!

KED

"RagDyer" wrote:

You asked for instructions to *copy*, and that's what DannyS gave you.

What you're describing here is actually looking to *link* cells, since
you
want changes in the original cells to be reflected in the "other" cells.

This formula can be entered *anywhere*, and copied down as needed:

=INDEX(RN!$6:$6,ROWS($1:2))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"ked" wrote in message
...
Hi Danny:
I tried this however it doesn't completely work for me, because I
notice
when I change a date in the original sheet RN it doesn't copy into the
sheet
ALL that I copied to. Any suggestions?

"DannyS" wrote:

Copy your rows, then click in the destination cell where you want to
copy.
Select Edit | Paste special. Tick the transpose box, then hit ok.

"ked" wrote:

I am trying to copy the data in row 6 in a spreadsheet - data
range -
b6:aq6
in worksheet RN to the destination of column T in worksheet ALL. I
am
not
being successful in making it copy across - can this be done?