Loop through column to find EID then find date and paste corresponding data

Hi Experts,

I am new to vba and would like to seek help in exporting my class attendance data into an existing csv file that serves as database. What i need to do is first find if the EID (trainee ID) is already in the database by looking through column E of the csv file and if found, i need to look at the dates in row 1 and paste the corresponding data for that trainee. i have already created a code to export trainee data to a registry database but it is with the assumption that the trainee is not in that db yet. Below is a snapshot of the table i need to export into the attendance csv file.

tracker.PNG

Please Login or Register  to view this content.

I have attached a sample file with a before and after tab though please note that output should be in another workbook. and i only have a few trainees in the list but the output file may have more and i need to look for the EIDs in the first tab, locate them on the output file before i copy over data. if the EID is not found, then i copy the data on the next available row.

Thanks for the response. However, this code only copies the data...i need for it to find the matching date in row 1 and put in the data in that column.