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?
More Information:
  1. However, most people when creating a list in Excel will often leave a blank cell if the data for that cell is the same as the cell above
  2. How to Create a Spreadsheet Template in Excel · How to Make a Circle Graph With Excel · How to Create a Message Box in Excel VBA
  3. Add-on classes on Thursday: 8:30 - Excel - Intro to VBA for Excel starting at the very basics - Bernard Liengme
  4. Find the directory part (minus the filename) of a full path in access 97 · Want VBA in excel to read very large CSV and create output file of a small subset of the CSV · VBA-Sorting the data in a listbox, sort works but data in listbox not changed
  5. Definitive Guide to Excel VBA, Second Edition by Michael Kofler This shows using andvanced filters to accomplish what I think you are trying to do, but
  6. Check for cells that contain formulas but output a space instead of any value in Excel
  7. Creating An Add-In, Date And Time Quick Entry, Date And Time VBA Functions, Date And Time Worksheet Functions, Date And Times In Excel, Date Arithmetic

More: