How to Hyperlink Resource Drive Auto update for Resource File.

Dear All,

I need a help.

I have excel 2010 sheet were i given the below hyperlink formula, But when i copied the both the excel sheet & Resource File, & pasted in another Laptop,

The drive need to change manually, then only it works.

Example in my Desktop it was in "D: Drive, and when i copied in the lap top it was in G: location.

Is there any formula to auto update the drive.


Desktop Location
=HYPERLINK("D:\Network Reconstruction\Images\MEHDIPATNAM IMAGES\SHOBAN PICS\DEC14/" & $A2 )

Laptop or Hard Disk Location.
=HYPERLINK("G:\Network Reconstruction\Images\MEHDIPATNAM IMAGES\SHOBAN PICS\DEC14/" & $A2 )

Regards,
Krishna.

Hi Zodeeak,

I know this one, But i want a formula for auto update same .