A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Using spreadsheet to fill in forms



 
 
Thread Tools Display Modes
  #1  
Old March 16th, 2010, 08:26 PM posted to microsoft.public.excel.worksheet.functions
Nicci
external usenet poster
 
Posts: 8
Default 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  
Old March 16th, 2010, 09:13 PM posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
 
Posts: 20,252
Default 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  
Old March 16th, 2010, 09:48 PM posted to microsoft.public.excel.worksheet.functions
Eva
external usenet poster
 
Posts: 316
Default 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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:32 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.