View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eva Eva is offline
external usenet poster
 
Posts: 197
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