LinkBack URL
About LinkBacks
copy and paste the below In any cell of column-A
=ADDRESS(38+COLUMN(A1),1,4,1)
Drag it right
copy and paste the below In any cell of column-A
=ADDRESS(38+COLUMN(A1),1,4,1)
Drag it right
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
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
Could you please describe it a bit more for my better understanding or attach a sample workbook with expected output will be helpful.
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
In C1 cell of sheet2
Formula:
=INDIRECT(ADDRESS(COLUMN(A1),1,2,TRUE,"Sheet1"))
Drag it right
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks