Thread: Transpose link
View Single Post
  #5  
Old June 3rd, 2010, 12:11 PM posted to microsoft.public.excel.worksheet.functions
Ms-Exl-Learner
external usenet poster
 
Posts: 522
Default Transpose link

Try this…

Copy and paste the below formula in A1 cell.
=INDIRECT(ADDRESS(1,COLUMN(B1)+ROW()))

Drag it to the remaining cells of A column.

--------------------
(Ms-Exl-Learner)
--------------------


"Ana via OfficeKB.com" wrote:

Stand in cell A1, enter "=C1"uses the "drag link cell" in the down right
corner of a cell. I will automaticly link
A1 - C1
A2 - C2
A3 - C3 ect

My question is if it is possible to drag horisonal and link vertically???

A1 - C1
A2 - D1
A3 - E1

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/201006/1

.