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?