Hello

I'm working a project where I've got a list of names in one spreadsheet, and
I need to pull corrasponding data from another spreadsheet. The concept is
simple.... get a name from spreadsheet1, then go into spreadsheet2, find
that username, and copy the row over to spreadsheet1. At least that is how
you do it manually.

In excel VBa, from one workbook, how do I a open another workbook and
worksheet then get the correct data i need?