If the value you input is part of the file name, you could do your input in one
cell and use the =hyperlink() worksheet function in the adjacent cell:

=hyperlink("file:////c:\yourpathtothefile\"&a1&".xls","Click me")
or
=hyperlink("file:////c:\yourpathtothefile\"&text(a1,"0000")&".xls","Cli ck me")

Change the drive letter and path (or UNC path) and the extension to what you
need.


Mike wrote:

Is there anyway I can input a number in excel and have excel link that number
to a invoice templete I created automatically?

I am not very familiar with hyperlink and how it works.

Your help is appreciated!

Thank you
Mike

--

Dave Peterson