Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create Invoice in Excel?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create Invoice in Excel?
If you're looking to auto-increment invoice numbering, take a look he
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. "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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create Invoice in Excel?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create an Invoice from a row of data | Excel Discussion (Misc queries) | |||
How do I create an invoice in Microsoft Excel? | Excel Discussion (Misc queries) | |||
how do I create an invoice from a spreadsheet | New Users to Excel | |||
Create invoice from Excel worksheet | Excel Discussion (Misc queries) | |||
In Excel, how do you create a multi page Invoice Template? | Excel Discussion (Misc queries) |