Auto hyperlink file from specific folder after enter file name in cell

Hi members,

I have a workbook. Which contain PANDCARD details in it. Here I am looking for a vba code which will automatic create hyperlink to image file in specific folder. (File names are pancard numbers)

In Folder "C:\Pancards contain Pancard scancopies" with file name as pan card number.

As soon as I enter pancard number entered in B column hyperlink should be create with file contain in "C\Pancards" Folder.

sorry for broken english.

your help may appreciated.

Regards,
Nandkumar S.

if you data is in B1, put this in A1 to create the link

=HYPERLINK("C:\Pancards contain Pancard scancopies\"& B1)

Ohhhh Yes



Thanks

you're welcome