Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 40
Default Transposing a pasted link row into a column

Hi,

I need to link a row of data into a column of data (in the same workbook).
The Source worksheet will be changed periodically. I have tried all
variations of paste special and paste link and cannot figure out how to do
this. Help Please!!

example worksheet 1 (E1:Z1) to transpose this row into a column on
Worksheet 2 (F1:F26). However, the source worksheet 1 will have new data
entered so worksheet 2 must be linked to to worksheet 1.

Instead of just copying and clicking on the "paste link" option to take a
row in worksheet 1 to worksheet 2, how do I make it a column in worksheet 2?
Thanks,
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default Transposing a pasted link row into a column

You can enter this in F1 of Sheet2, OR, *anywhere* else you wish, and still
get the data you're looking for:

=INDEX(Sheet1!$E$1:$Z$1,ROWS($1:1))

Copy down as needed.

NOTE ... E1 to Z1 is *only* 22 columns,
NOT the 26 you mentioned!
--
HTH,

RD

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

"Eden397" wrote in message
...
Hi,

I need to link a row of data into a column of data (in the same workbook).
The Source worksheet will be changed periodically. I have tried all
variations of paste special and paste link and cannot figure out how to do
this. Help Please!!

example worksheet 1 (E1:Z1) to transpose this row into a column on
Worksheet 2 (F1:F26). However, the source worksheet 1 will have new data
entered so worksheet 2 must be linked to to worksheet 1.

Instead of just copying and clicking on the "paste link" option to take a
row in worksheet 1 to worksheet 2, how do I make it a column in worksheet
2?
Thanks,



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 281
Default Transposing a pasted link row into a column

Hi,

Try this:

in the cell F26 enter this formula

=INDIRECT("sheet1!"&CHAR(68+ROW())&"1")

and then copy drag to F26

Thanks,

--
Farhad Hodjat


"Eden397" wrote:

Hi,

I need to link a row of data into a column of data (in the same workbook).
The Source worksheet will be changed periodically. I have tried all
variations of paste special and paste link and cannot figure out how to do
this. Help Please!!

example worksheet 1 (E1:Z1) to transpose this row into a column on
Worksheet 2 (F1:F26). However, the source worksheet 1 will have new data
entered so worksheet 2 must be linked to to worksheet 1.

Instead of just copying and clicking on the "paste link" option to take a
row in worksheet 1 to worksheet 2, how do I make it a column in worksheet 2?
Thanks,

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 281
Default Transposing a pasted link row into a column

Sorry you have to enter the formula in the cell F1 and then copy drag to cell
F26

Thanks,
--
Farhad Hodjat


"Farhad" wrote:

Hi,

Try this:

in the cell F26 enter this formula

=INDIRECT("sheet1!"&CHAR(68+ROW())&"1")

and then copy drag to F26

Thanks,

--
Farhad Hodjat


"Eden397" wrote:

Hi,

I need to link a row of data into a column of data (in the same workbook).
The Source worksheet will be changed periodically. I have tried all
variations of paste special and paste link and cannot figure out how to do
this. Help Please!!

example worksheet 1 (E1:Z1) to transpose this row into a column on
Worksheet 2 (F1:F26). However, the source worksheet 1 will have new data
entered so worksheet 2 must be linked to to worksheet 1.

Instead of just copying and clicking on the "paste link" option to take a
row in worksheet 1 to worksheet 2, how do I make it a column in worksheet 2?
Thanks,

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Unprotect Hyperlink (pasted Link has blocked:: in it) Aconite Excel Discussion (Misc queries) 0 November 30th 06 03:44 PM
Transposing a row into a column Raj Excel Discussion (Misc queries) 4 July 25th 06 11:09 PM
right function on pasted link Bob Excel Worksheet Functions 1 November 4th 05 10:58 PM
Transposing a column to several rows [email protected] Excel Worksheet Functions 4 May 26th 05 10:06 PM
Transposing column to row doesn't work Joe Excel Discussion (Misc queries) 4 March 23rd 05 08:35 PM


All times are GMT +1. The time now is 04:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"