hyperlink the content in row to display in column

[Sanjeevk]

I have a worksheet which contains multiple rows with following columns
Code, Name, Address, Phone, Fax, Age

How can the name be made clickable to view the row content in two columns like
column1 , column2
Code X001
Name James
Address .....
Phone xx-1-xxxxxx
Fax yy-2-yyyyyy
Age 25

 

[kchiba]

Hi Sanjeev,

please upload a file with sample data of more that one record

 

[Somendra Misra]

Hi Sanjeev,

Have a look of attached file. Is this what you want? I had used VBA to achieve this.

Somendra.

 

[SirJB7]

Hi, Sanjeevk!

Give a look at the uploaded file. It's an alternative without using VBA.

It uses a dynamic named range:
SelectecCodeCell: =INDIRECTO(CELDA("address")) -----> in english: =INDIRECT(CELL("address"))
and this formula for J column:
J1: =SI(Y(FILA(SelectedCodeCell)>1;SelectedCodeCell<>"");INDICE(A:F;FILA(SelectedCodeCell);FILA());"") -----> in english: =IF(AND(ROW(SelectedCodeCell)>1,SelectedCodeCell<>""),INDEX(A:F,ROW(SelectedCodeCell),FILA()),"")

The only drawback is that you have to select or click on any column of the wanted row (not just on B) but you then have to press F9, since it involves a function that should be recalculated.

Regards!