creating automatic hyperlinks

J

javaid.nadeem

I have made a spreadsheet where i need to hyper link to other workbooks
spanning into the hundreds of other sheets.
I have a customer number in column B then i have information etc and in
column N i have a hyper link to a seperate file. The name of the file
is the same as the customer number. Is there any way i can get excell
to as soon a a new customer number is enterd it will automaticly create
a hyperlink to its file in row N
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top