International Freight INVOICE - DataForm

Mar 4th, 2002, 05:02 AM

I am trying to set up an Excel based invoice system and would like to have a "FORM" for the employees to enter the data in with.

However, I have found that unless all the field names are in a single row, the Data|form function does not pick up all the fields

The fields are -

InvoiceNo ; Re: ; To: ;

Vessel: ; Ref:

To be laid out in a pattern of 2 : 2 : 1

If anyone can offer a solution to this problem, I would be most grateful

Many thanks

Peter

Anne Troy · Mar 4th, 2002, 05:59 AM

More than likely, this is your problem:

Headings MUST be in row 1, first record must be in row 2.

To have multiple-line headings, user Alt-Enter to get a paragraph return within a cell.

Hope that helps!

Mar 4th, 2002, 07:46 AM

Could I have a bit more help please I don't quite understand

Mar 4th, 2002, 05:59 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	More than likely, this is your problem: Headings MUST be in row 1, first record must be in row 2. To have multiple-line headings, user Alt-Enter to get a paragraph return within a cell. Hope that helps! __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 4th, 2002, 05:02 AM	#1
Guest Posts: n/a	I am trying to set up an Excel based invoice system and would like to have a "FORM" for the employees to enter the data in with. However, I have found that unless all the field names are in a single row, the Data\|form function does not pick up all the fields The fields are - InvoiceNo ; Re: ; To: ; Vessel: ; Ref: To be laid out in a pattern of 2 : 2 : 1 If anyone can offer a solution to this problem, I would be most grateful Many thanks Peter

Mar 4th, 2002, 07:46 AM	#3
Guest Posts: n/a	Could I have a bit more help please I don't quite understand