combine two reports accordingly

[wahbi]

So i have two reports in two sheets, the first report "main" is a list of students and some information about them (like grade level, birthday, address, etc) The second sheet is a another report with students that might exist in the first sheet, but on the second sheet they have different information about them (like username, classes, etc). I need a VBA that will take the students names from the second sheet, look to see if they exist in the main sheet"first sheet" if yes, add the information of that student from the second sheet (the whole row) to the first sheet and line it up on the same row, so its added right next to the last cell in the row in the first sheet. I was thinking about the lookup function .. would that be a good one to use here?

[popipipo]

You can use VLOOKUP
This only works if there is a unique item (name, birthday?) on both sheets.
Something like this:

Please Login or Register  to view this content.

[FDibbins]

Hi and welcome to the forum

vlookup or index match will probably give you what you want, without the need for any VBA.

If you still have a problem, i would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[wahbi]

Thank you everyone for your help. I have attached a file here .. So we have the main report that includes students and some info about them and we have report 1, the second sheet, that has students and other info. the two report have students in common and a unique user name, that is how we can join the two reports. the third sheet is the expected result. Note that the header is copied as well. Thank you very much again, I am looking forward to your ideas.

PS. how do you use Vlookup to get multiple columns in this case? Thank you very much again.