You can hide individual sheets in the workbook. As an alternative, you can
close the workbook after you have copied your data. Open and close it as
needed. Unless it is a very large workbook, it doesn't take much longer to
close and open than to hide and unhide the sheets.




"Peter" wrote in message
...
Thanks for the help that works, just one more question.

When I open the second workbook, the one that I'm coping data from
Workbooks.Open Filename:="c:\UserInfor.xls" the workbook actually opens
and is visible to the user. Is there a way to hide it so a person can't
see it?


"Peter" wrote in message
...
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?