Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: International Freight INVOICE - DataForm

  1. #1


    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


  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Westwood NJ
    Post Thanks / Like
    0 Post(s)
    0 Thread(s)


    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

  3. #3


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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts