1. ## vertical linking of cells

Hello Everyone.!
is there any method to make verical linking of cells..?
Not getting my point??
Ok.. Here is an example
A1=m
A2=n
A3=o
A4=p
.....onwards....
if i put value of
B1 to ---> "=A1" ,, indirectly saying "m"
and
of C1 to ---> "=A2",, indirectly saying "n"
Then can i use any method by which it automaticaly takes value of the next cells? i.e. D1 = "=A3" , E1 = "=A4" , and onwards??  Reply With Quote

2. Hay,
You have 2 possibility :
- Copy the data, select the cell where you want the first data, Paste Special then Transpose
- By formula, select the first cell where you want the first data, select in horizontal the same number of vertical cell, wrote the formula =TRANSPOSE(A1:A4) and valid by Ctrl+Shift+Enter (Array Formula result {=TRANSPOSE(A1:A4)})
You can also put your data in a table and the formula will be =TRANSPOSE(Table name) and also valid as an array formula
Best regards  Reply With Quote

3. One easy way is to enter zzA1 in B1 and zzA2 in C1, select both cells then drag across as far as you want. Now replace (Ctrl+H) zz with =
Alternatively, IN b1:
=INDEX(\$A:\$A,column()-1)
and copy across.  Reply With Quote

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•