Hi Again All
I have a spread sheet application that has caused a few complaints from staff about data entry being tricky - and has caused some errors in that data entry. Therefore I want to create a simpler, easier to use application for that data entry, and am wondering whether the excel data form method is the best option.
The new table (tab is called CourseDel) consists of the following:
Col A: Course Number - drawn from a drop down list created on a separate tab called data.
Col B: Course Title - I want to use VLOOKUP or HLOOKUP to enter the title automatically when selected the Course Number.
Col C: Class Number - simple data entry in the form of 01/16, 02/16 etc
Col D: Date Started - simple data entry in the format dd-mmm-yy.
Col E: Date Complete - as above.
Col F: Number of Students - simple number.
Col G: Enabling Objectives Complete - drop down list from the data tab simply as Y or N.
Col H: Task Book Issued - Some courses require some consolidation before full completion of the course - this is a Y or N drop down from the data tab.
Problem 1: When I created the Data Form - it does not recreate the drop down lists that I need to ensure data entry accuracy. How do I do this?
Problem 2: How can I apply the VLOOKUP or HLOOKUP to the Course Title field?
Problem 3: When instructors open this spreadsheet to enter data, do I need a simple macro to open the form?
Q1: Is there a simpler way to make this process work? I need:
- accuracy of data entry for stats purposes.
- simple to use for the instructors - and to reduce their burden entering data.
Many thanks in advance - I always appreciate your thoughts. Hopefully I have explained it well enough.
Matt
I have a spread sheet application that has caused a few complaints from staff about data entry being tricky - and has caused some errors in that data entry. Therefore I want to create a simpler, easier to use application for that data entry, and am wondering whether the excel data form method is the best option.
The new table (tab is called CourseDel) consists of the following:
Col A: Course Number - drawn from a drop down list created on a separate tab called data.
Col B: Course Title - I want to use VLOOKUP or HLOOKUP to enter the title automatically when selected the Course Number.
Col C: Class Number - simple data entry in the form of 01/16, 02/16 etc
Col D: Date Started - simple data entry in the format dd-mmm-yy.
Col E: Date Complete - as above.
Col F: Number of Students - simple number.
Col G: Enabling Objectives Complete - drop down list from the data tab simply as Y or N.
Col H: Task Book Issued - Some courses require some consolidation before full completion of the course - this is a Y or N drop down from the data tab.
Problem 1: When I created the Data Form - it does not recreate the drop down lists that I need to ensure data entry accuracy. How do I do this?
Problem 2: How can I apply the VLOOKUP or HLOOKUP to the Course Title field?
Problem 3: When instructors open this spreadsheet to enter data, do I need a simple macro to open the form?
Q1: Is there a simpler way to make this process work? I need:
- accuracy of data entry for stats purposes.
- simple to use for the instructors - and to reduce their burden entering data.
Many thanks in advance - I always appreciate your thoughts. Hopefully I have explained it well enough.
Matt