Fix Column, Change Number

[feinomore]

hi, i know stupid question.

but i need help with this.
i want fix column A but not number, and a want apply it for a row. like

$A39 $A40 ....

i can do it for a column, but not for a row. any help??

[twiggywales]

A$39

the $ before a letter of number "locks" that value

[feinomore]

i want do this:

[:) Sixthsense :)]

copy and paste the below In any cell of column-A

=ADDRESS(38+COLUMN(A1),1,4,1)
Drag it right

[feinomore]

hmm, thanks Sixthsense... but it doesnt work.. i dont know why. i am just trying it on new excel.

A B C D
1 x
2 y
3 z

i do this =address(1,1,2,true,"Sheet1), but excel said: formula contain an error

[:) Sixthsense :)]

Could you please describe it a bit more for my better understanding or attach a sample workbook with expected output will be helpful.

[feinomore]

I have column e.g. A and there are values A1=a A2=b A3=c. What i need is to take these values and copy it to row.

Sheet1: A1=a A2=b A3=c
Sheet2: C1='Sheet1'!$A1, and than i want drag it to right for automatically add other data from sheet1

[:) Sixthsense :)]

In C1 cell of sheet2

=INDIRECT(ADDRESS(COLUMN(A1),1,2,TRUE,"Sheet1"))

Drag it right

[twiggywales]

or

in C1

=INDEX(Sheet1!$A$1:$A$15,COLUMN(Sheet2!A$1))

the a15 can be changed to whatever your last cell is. then drag right.

this would be better as it doesn't use indirect (which is volatile)

[twiggywales]

or

in C1

=INDEX(Sheet1!$A$1:$A$15,COLUMN(Sheet2!A$1))

the a15 can be changed to whatever your last cell is. then drag right.

this would be better as it doesn't use indirect (which is volatile)

[feinomore]

=INDEX(Sheet1!$A$1:$A$15,COLUMN(Sheet2!A$1)) works, but i changed , with ;

thx

p.s.: how can i mark it SOLVED?

[feinomore]

what means COLUMN(Sheet2!A$1) ???

[twiggywales]

thread tools at the top of the page.

[twiggywales]

this returns the number of the column in the brackets (a=1 b=2 c=3) etc. so when you drag it this is used to index the next row in your original list

[feinomore]

cool, now i understand. thx u so much for your help. very good job!!