Create Invoice in Excel?

[Mike]

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

 

[JLatham]

If you're looking to auto-increment invoice numbering, take a look here:
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

As for linking from one cell in (any) Excel workbook to another cell in
either the same workbook or another one, that's easy to do:
If multiple workbooks are involved, open both/all of them.
Start in the workbook that's to have a copy of the number, choose the cell
and type the = symbol.
Then go to the other workbook/sheet/cell with the number to be 'copied' and
select that cell and simply hit the [Enter] key. The link is created.

But each invoice would need to be linked to a different source cell, because
if all invoices link to the same invoice number cell somewhere, then when you
change the source invoice number, all invoices linked to that cell would show
the same number.

 

[Dave Peterson]

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","Click me")

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