copying information from rows to columns
 

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?

copying information from rows to columns
 

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?

copying information from rows to columns
 

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?

copying information from rows to columns
 

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?

copying information from rows to columns
 

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?

copying information from rows to columns
 

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?

copying information from rows to columns
 

what i mean is that when i copy the formula my row 2 &3 become row 2 in
column T, when i try to fill down - rows 4&5 merge together and so on all the
way down that column.

i'm very puzzled!

"RagDyer" wrote:

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?

copying information from rows to columns
 

Open a brand new worksheet in the *same* workbook as "RN".

Copy and paste the formula into A1.

Drag down to copy.

What happens?
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"ked" wrote in message
...
what i mean is that when i copy the formula my row 2 &3 become row 2 in
column T, when i try to fill down - rows 4&5 merge together and so on all
the
way down that column.

i'm very puzzled!

"RagDyer" wrote:

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?