keep links when copied to different computer

L

Lorry

I have a large excel database of medical patients - naems conditions etc. I also have scanned each test they have had
I would like to hyperlink from the patients name to a separate pdf file with their reports

The problem is that i would like to have the database and the file on three separate computers.
How do i set it up so that the links work on my computer and alsot the other computers when i put a copy of the database and the report pdfs on

Sorry if this is very simple but i'm a novice trying hard and going gre

LD
 
R

Ron de Bruin

One way

Use this with in A1 the path C:\Data\

=HYPERLINK(A1&"test1.xls","test1.xls")

If you chanage the path in A1 all links are changed
 
L

lorry

Thank you for your reply. I am a beginner so i dont really understand it very well.

Are you saying that i sould click on the first cell (eg A1) then in the formula box type in C:/data (where data is the address of the pdf report?) = hyperlink(a1&"test1.pdf".test1.pdf) - when i type test 1.pdf, an i typing the name of the test?

sorry to be dumb

Lorry

----- Ron de Bruin wrote: -----

One way

Use this with in A1 the path C:\Data
=HYPERLINK(A1&"test1.xls","test1.xls")

If you chanage the path in A1 all links are changed
 
R

Ron de Bruin

in A1 you enter the path of your pdf files

For example
C:\Data\

In a other cell you enter this formula
=HYPERLINK(A1&"SendMail 3.1 for Outlook User Guide.pdf";"click me")

Try it


--
Regards Ron de Bruin
http://www.rondebruin.nl


lorry said:
Thank you for your reply. I am a beginner so i dont really understand it very well.

Are you saying that i sould click on the first cell (eg A1) then in the formula box type in C:/data (where data is the address of
Click to expand...
the pdf report?) = hyperlink(a1&"test1.pdf".test1.pdf) - when i type test 1.pdf, an i typing the name of the test?
 
Top