programmed hyperlinks

[nadznadz]

I have made a spreadsheet where i need to hyper link to other workbook

spanning into the hundreds of other sheets.
I have a customer number in column B then i have information etc and i

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 creat

a hyperlink to its file in row

 

[Guest]

look at the hyperlink worksheet function

A simplified example
=if(A1="","",Hyperlink(A1))

you would need to prefill you cells with such formulas.