I am working with two worksheets of data which can be related based on a
common field between the two. I want to add data from one worksheet to the
rows of the other and i'm guessing I would do that based on the unique field
in both reports i.e. student ID number, but I dont know how to set this up. I
have Excel 2007. Help!