Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
linking data to specified fields
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. -- CSC |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
linking data to specified fields
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 "Craig" wrote: 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. -- CSC |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking PivotTable Fields - Excel 2007 | Excel Discussion (Misc queries) | |||
linking (?) fields from one worksheet to another? | Excel Worksheet Functions | |||
Linking MS Project fields in Excel | Excel Discussion (Misc queries) | |||
linking pivot tables by page fields | Excel Programming | |||
Linking Embedded Document Fields | Excel Discussion (Misc queries) |