Hello Experts,
I need your assistance. I'v a workbook which has 4 sheet. I want to create a
automatically hyperlink (through formulae) when I change content of cell a2,
hyperlink automatically should change...Please help me.
Thnx
*---
кαяαηη*
--
Hi Karan,
Copy and paste the below formula in B2 cell of your Index sheet.
=HYPERLINK(
CONCATENATE("[",MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1),"]",A2,"!B1"),"Click
Here")
or
=HYPERLINK(
CONCATENATE("[",MID(CELL("fi
Dear Karan find the attachment.
--
*Great day,*
*
Thamu*
On Tue, Jun 7, 2011 at 1:40 PM, karan 1237 wrote:
> Hello Experts,
>
> I need your assistance. I'v a workbook which has 4 sheet. I want to create
> a automatically hyperlink (through formulae) when I change content of cell
> a2, h
Hi Karan,
please find attached file with the result.
i have included one formula in the same sheet for your reference.
thanks,
saber
On Tue, Jun 7, 2011 at 1:40 PM, karan 1237 wrote:
> Hello Experts,
>
> I need your assistance. I'v a workbook which has 4 sheet. I want to create
> a automatica
Thnx again to all of you for solving my problem. You all are great!
*---
кαяαηη*
On Tue, Jun 7, 2011 at 4:39 PM, mohd saber wrote:
> Hi Karan,
>
> please find attached file with the result.
>
> i have included one formula in the same sheet for your reference.
>
> thanks,
> saber
>
> On T
