linking data to specified fields

[Craig]

I have student test data from many different sources. How do I import the
data from different sources and link the correct scores to the student ID
numbers - each source has the same ID numbers for 500 students. I am
attempting to create a master list of student data without having to manually
type in each score for each student.

 

[Joel]

Are the souces other excel files, text files, or othe type sources?

Linking means the sources are other excel files. If so you need to open
each workbook to find the student to perform the link (except if the students
are always in the same location). You can also search folders to find all
the files you are looking for. for example

Folder = "C:\temp"
Files = "Student Grades *.xls"

FName = dir(Folder & "\" & Files")
do while FName <> ""
set Test_BK = Workbooks.Open(filename:=Folder & "\" & FName)

'put your code here

Tesk_Bk.Close
FName = Dir()
loop

Dir the frist time use you put in the Folder and File Name. Calling it
again with no parameters gets all the files with the specified criteria