These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Thursday, April 18, 2013

Sheet merger for student database


This VBA macro was written in response to a request from the TA of the professor of the Family Finance class on BYU campus. The macro was requested when merging a sheet full of data from students’ questionnaires with a sheet that is called the “Student Database” that has all the rest of the student information became monotonous.

The idea of this macro is to find open the student questionnaire sheet, get the data out, check for duplicates, and fill in the missing data for each student in the Student Database. This allows the professor to sort through the data as appropriate and email certain students based off of certain criteria (i.e., students who took the class in fall 2012).


No comments:

Post a Comment

Blog Archive