Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using spreadsheet to fill in forms
We need to create a form of an invoice in a very specific format (determined
by an international shipping company). We will have several items which will need to be filled in on every invoice. We would like to be able to fill in all the pertinent invoice information on a spreadsheet and have each line populate the form/invoice to save & print. I have used forms in the past in which we just tab from text entry to text entry but we're hoping to make this easier on the user by using a spreadsheet or some other form instead of bouncing all over a form. Is there a way to do this? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using spreadsheet to fill in forms
One method..........there will be others.
I would create a workbook with one sheet.......Invoice sheet........and save that workbook as a Template. Add VLOOKUP formulas referring to an input sheet in another workbook. The other workbook has a sheet where data is entered in a linear fashion. Column A has descriptive text in A1:A10 B1:B10 is where you enter values to be returned to Invoice sheet. Once Invoice sheet has been filled it can be saved and inputs workbook B1:B10 cleared for next Invoice. If you wanted it all in one workbook you could simply copy the filled Invoice sheet to a new workbook then clear the input sheet. Gord Dibben MS Excel MVP On Tue, 16 Mar 2010 12:26:01 -0700, Nicci wrote: We need to create a form of an invoice in a very specific format (determined by an international shipping company). We will have several items which will need to be filled in on every invoice. We would like to be able to fill in all the pertinent invoice information on a spreadsheet and have each line populate the form/invoice to save & print. I have used forms in the past in which we just tab from text entry to text entry but we're hoping to make this easier on the user by using a spreadsheet or some other form instead of bouncing all over a form. Is there a way to do this? Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using spreadsheet to fill in forms
Hi
This is easly to do. Create data sheet with all the information in one sheet then create a form in the other and link both, or use the formula vlookup, index, match - it does matther what you are doing. -- Please click "yes" if this post helped you! Greatly appreciated Eva "Nicci" wrote: We need to create a form of an invoice in a very specific format (determined by an international shipping company). We will have several items which will need to be filled in on every invoice. We would like to be able to fill in all the pertinent invoice information on a spreadsheet and have each line populate the form/invoice to save & print. I have used forms in the past in which we just tab from text entry to text entry but we're hoping to make this easier on the user by using a spreadsheet or some other form instead of bouncing all over a form. Is there a way to do this? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill-in Forms | Excel Discussion (Misc queries) | |||
Auto fill in forms | Excel Worksheet Functions | |||
how can i fill in information once and use it for several forms | Excel Discussion (Misc queries) | |||
How do I make fill-in-the-blank forms, with Excel? | New Users to Excel | |||
How do I create a template to fill in government forms? | Excel Worksheet Functions |