Pulling Data From Other Workbook Based On Matching Cells

[FRin323]

Hello everyone!

I am working on a macro that would look at the value in a cell (let's call it a Student ID) and match that value to a workbook where all the students are stored and then populate the student's name one cell over in the original work book where the Student ID was. It would do this till it read the last Student ID number in a certain column.

I'm fairly new to VBA for Excel so this has had me stuck for a few weeks. I've looked at several tutorials and I've gotten snippets of code that would let me extract cell values from other workbooks but it's not really based on anything. I know a loop of some sort would be needed and a defined function that would probably go in the loop. Any suggestions or even code would be really helpful! I thank you in advance!

Regards,
Efrain P.

[nimrod]

Without knowing names of source and target; paths, directories, filenames, sheet names , columns involved etc ... this is the best i can do.

Please Login or Register  to view this content.

[FRin323]

Wow! I'm going to go over that to see if I can understand it! Thank you very much!

[nimrod]

Const ClosedRefReturnColumn As String = "2" SHOULD BE Const ClosedRefReturnColumn As Integer = 2

[FRin323]

Ignore this post

[FRin323]

Ignore the previous post with the code. I've been looking at the code again for hours and it seems like the error lies wither in the Execute4Macro function or the VLookup function. Either way, there's no value being read into the ReturnedValue variable causing the exception handler to execute and giving me a mismatch error back up in the Cells.(...).Value assignment line.

I'm also still confused about the ClosedRefReturnColumn Integer does?

Here's my code so far:

Please Login or Register  to view this content.