Excel VBA: Sorting and Creating an output

Discussion in 'Programming' started by cre8ive, Jun 12, 2008.

  1. #1
    My client has an Excel spreadsheet that keeps track of his company's manufacturing process. It has columns like ...

    Employee code
    Type of product he's working on
    Starting date
    Ending date
    Etc.

    Works fine, but he wants a very simple interface that anyone can use including those who really don't know how to use computers. One feature he wants is the following. He wants a very user friendly form; the user enters probably something like ...

    Employee code
    Type of product he's working on
    Starting date and
    Ending date

    As the user clicks submit, this small application creates a new printable spreadsheet / form / something like that. Can this small application be made using VBA? If so, how do I go about this?
     
    cre8ive, Jun 12, 2008 IP