Copy data from one Excel to another without opening

[gn_love_vel_m21]

HI,

Anyone please help me in the below situation.

I have 2 Excel files in a Folder.

One Workbook is Main File(QCT.xls)

Second Workbook(Lookup.xls) is Input file for user.

I need a VBA macro for the second file to copy data from the Main file without opening the Main file (QCT.xls). (note: both files are in the same folder)

Example:

Main File -> Sheet Name(SourceData)

<table border="0" cellpadding="0" cellspacing="0" width="544"><colgroup><col style="width:48pt" span="6" width="64"> <col style="mso-width-source:userset;mso-width-alt:5851;width:120pt" width="160"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;width:48pt" height="20" width="64">ID</td> <td class="xl63" style="border-left:none;width:48pt" width="64">Last Name</td> <td class="xl63" style="border-left:none;width:48pt" width="64">First Name</td> <td class="xl63" style="border-left:none;width:48pt" width="64">Class</td> <td class="xl63" style="border-left:none;width:48pt" width="64">Major</td> <td class="xl63" style="border-left:none;width:48pt" width="64">Residence</td> <td class="xl63" style="border-left:none;width:120pt" width="160">Email</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl64" style="height:15.0pt;border-top:none" align="right" height="20">391455</td> <td class="xl64" style="border-top:none;border-left:none">Hellung</td> <td class="xl64" style="border-top:none;border-left:none">Anne</td> <td class="xl64" style="border-top:none;border-left:none">Junior</td> <td class="xl64" style="border-top:none;border-left:none">Sociology</td> <td class="xl64" style="border-top:none;border-left:none">Sted-1</td> <td class="xl64" style="border-top:none;border-left:none">annehel11@xyz.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl64" style="height:15.0pt;border-top:none" align="right" height="20">391885</td> <td class="xl64" style="border-top:none;border-left:none">Thorpe</td> <td class="xl64" style="border-top:none;border-left:none">Steven</td> <td class="xl64" style="border-top:none;border-left:none">Junior</td> <td class="xl64" style="border-top:none;border-left:none">Business</td> <td class="xl64" style="border-top:none;border-left:none">off-campus</td> <td class="xl64" style="border-top:none;border-left:none">steventh@abc.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl64" style="height:15.0pt;border-top:none" align="right" height="20">392337</td> <td class="xl64" style="border-top:none;border-left:none">Ramos</td> <td class="xl64" style="border-top:none;border-left:none">Luciana</td> <td class="xl64" style="border-top:none;border-left:none">Sophomore</td> <td class="xl64" style="border-top:none;border-left:none">Engineering</td> <td class="xl64" style="border-top:none;border-left:none">Sted-1</td> <td class="xl64" style="border-top:none;border-left:none">lucramos@sample.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl64" style="height:15.0pt;border-top:none" align="right" height="20">392722</td> <td class="xl64" style="border-top:none;border-left:none">Freehafer</td> <td class="xl64" style="border-top:none;border-left:none">Nancy</td> <td class="xl64" style="border-top:none;border-left:none">Sophomore</td> <td class="xl64" style="border-top:none;border-left:none">Social Studies</td> <td class="xl64" style="border-top:none;border-left:none">Sted-2</td> <td class="xl64" style="border-top:none;border-left:none">nancyfree@sample.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl64" style="height:15.0pt;border-top:none" align="right" height="20">392901</td> <td class="xl64" style="border-top:none;border-left:none">O'Donnell</td> <td class="xl64" style="border-top:none;border-left:none">Martin</td> <td class="xl64" style="border-top:none;border-left:none">Sophomore</td> <td class="xl64" style="border-top:none;border-left:none">Mathematics</td> <td class="xl64" style="border-top:none;border-left:none">Unit 10C</td> <td class="xl64" style="border-top:none;border-left:none">martyo@ijk.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl64" style="height:15.0pt;border-top:none" align="right" height="20">393206</td> <td class="xl64" style="border-top:none;border-left:none">Anderson</td> <td class="xl64" style="border-top:none;border-left:none">Elizabeth</td> <td class="xl64" style="border-top:none;border-left:none">Freshman</td> <td class="xl64" style="border-top:none;border-left:none">undeclared</td> <td class="xl64" style="border-top:none;border-left:none">Unit 7</td> <td class="xl64" style="border-top:none;border-left:none">elandsn@ijk.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl64" style="height:15.0pt;border-top:none" align="right" height="20">393213</td> <td class="xl64" style="border-top:none;border-left:none">Lee</td> <td class="xl64" style="border-top:none;border-left:none">Christina</td> <td class="xl64" style="border-top:none;border-left:none">Freshman</td> <td class="xl64" style="border-top:none;border-left:none">Biology</td> <td class="xl64" style="border-top:none;border-left:none">Unit 10B</td> <td class="xl64" style="border-top:none;border-left:none">chisylee@zyx.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl64" style="height:15.0pt;border-top:none" align="right" height="20">393497</td> <td class="xl64" style="border-top:none;border-left:none">Neipper</td> <td class="xl64" style="border-top:none;border-left:none">Michael</td> <td class="xl64" style="border-top:none;border-left:none">Freshman</td> <td class="xl64" style="border-top:none;border-left:none">undeclared</td> <td class="xl64" style="border-top:none;border-left:none">Unit 9</td> <td class="xl64" style="border-top:none;border-left:none">mneipper@zyx.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl64" style="height:15.0pt;border-top:none" align="right" height="20">393501</td> <td class="xl64" style="border-top:none;border-left:none">LaRosa</td> <td class="xl64" style="border-top:none;border-left:none">Michael</td> <td class="xl64" style="border-top:none;border-left:none">Freshman</td> <td class="xl64" style="border-top:none;border-left:none">Engineering</td> <td class="xl64" style="border-top:none;border-left:none">off-campus</td> <td class="xl64" style="border-top:none;border-left:none">milar@zyx.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl64" style="height:15.0pt;border-top:none" align="right" height="20">393592</td> <td class="xl64" style="border-top:none;border-left:none">Sergienko</td> <td class="xl64" style="border-top:none;border-left:none">Mariya</td> <td class="xl64" style="border-top:none;border-left:none">Freshman</td> <td class="xl64" style="border-top:none;border-left:none">Biology</td> <td class="xl64" style="border-top:none;border-left:none">Unit 10A</td> <td class="xl64" style="border-top:none;border-left:none">mariyaser@zyx.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl64" style="height:15.0pt;border-top:none" align="right" height="20">393599</td> <td class="xl64" style="border-top:none;border-left:none">Zare</td> <td class="xl64" style="border-top:none;border-left:none">Robert</td> <td class="xl64" style="border-top:none;border-left:none">Freshman</td> <td class="xl64" style="border-top:none;border-left:none">undeclared</td> <td class="xl64" style="border-top:none;border-left:none">Unit 8B</td> <td class="xl64" style="border-top:none;border-left:none">rzare@zyx.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl64" style="height:15.0pt;border-top:none" align="right" height="20">393660</td> <td class="xl64" style="border-top:none;border-left:none">Kotas</td> <td class="xl64" style="border-top:none;border-left:none">Jan</td> <td class="xl64" style="border-top:none;border-left:none">Freshman</td> <td class="xl64" style="border-top:none;border-left:none">Mathematics</td> <td class="xl64" style="border-top:none;border-left:none">Unit 9</td> <td class="xl64" style="border-top:none;border-left:none">jankotas@zyx.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl64" style="height:15.0pt;border-top:none" align="right" height="20">393667</td> <td class="xl64" style="border-top:none;border-left:none">Cencini</td> <td class="xl64" style="border-top:none;border-left:none">Andrew</td> <td class="xl64" style="border-top:none;border-left:none">Freshman</td> <td class="xl64" style="border-top:none;border-left:none">undeclared</td> <td class="xl64" style="border-top:none;border-left:none">Unit 10B</td> <td class="xl64" style="border-top:none;border-left:none">acencini@zyx.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl64" style="height:15.0pt;border-top:none" align="right" height="20">393674</td> <td class="xl64" style="border-top:none;border-left:none">Giussani</td> <td class="xl64" style="border-top:none;border-left:none">Laura</td> <td class="xl64" style="border-top:none;border-left:none">Freshman</td> <td class="xl64" style="border-top:none;border-left:none">Chemistry</td> <td class="xl64" style="border-top:none;border-left:none">Unit 8A</td> <td class="xl64" style="border-top:none;border-left:none">lauragius@zyx.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl64" style="height:15.0pt;border-top:none" align="right" height="20">393682</td> <td class="xl64" style="border-top:none;border-left:none">Kupkova</td> <td class="xl64" style="border-top:none;border-left:none">Helena</td> <td class="xl64" style="border-top:none;border-left:none">Freshman</td> <td class="xl64" style="border-top:none;border-left:none">undeclared</td> <td class="xl64" style="border-top:none;border-left:none">Unit 10A</td> <td class="xl64" style="border-top:none;border-left:none">helenag2@zyx.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl64" style="height:15.0pt;border-top:none" align="right" height="20">393683</td> <td class="xl64" style="border-top:none;border-left:none">Hasselberg</td> <td class="xl64" style="border-top:none;border-left:none">Jonas</td> <td class="xl64" style="border-top:none;border-left:none">Freshman</td> <td class="xl64" style="border-top:none;border-left:none">Comp Sci</td> <td class="xl64" style="border-top:none;border-left:none">Unit 8A</td> <td class="xl64" style="border-top:none;border-left:none">jonhasselberg@zyx.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl64" style="height:15.0pt;border-top:none" align="right" height="20">393872</td> <td class="xl64" style="border-top:none;border-left:none">Li</td> <td class="xl64" style="border-top:none;border-left:none">George</td> <td class="xl64" style="border-top:none;border-left:none">Freshman</td> <td class="xl64" style="border-top:none;border-left:none">Business</td> <td class="xl64" style="border-top:none;border-left:none">Unit 7</td> <td class="xl64" style="border-top:none;border-left:none">gli@zyx.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl64" style="height:15.0pt;border-top:none" align="right" height="20">491177</td> <td class="xl64" style="border-top:none;border-left:none">White</td> <td class="xl64" style="border-top:none;border-left:none">Eric</td> <td class="xl64" style="border-top:none;border-left:none">Senior</td> <td class="xl64" style="border-top:none;border-left:none">Math</td> <td class="xl64" style="border-top:none;border-left:none">off-campus</td> <td class="xl64" style="border-top:none;border-left:none">ericwhite@zyx.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl64" style="height:15.0pt;border-top:none" align="right" height="20">492862</td> <td class="xl64" style="border-top:none;border-left:none">Liu</td> <td class="xl64" style="border-top:none;border-left:none">Run</td> <td class="xl64" style="border-top:none;border-left:none">Sophomore</td> <td class="xl64" style="border-top:none;border-left:none">Chemistry</td> <td class="xl64" style="border-top:none;border-left:none">Unit 10A</td> <td class="xl64" style="border-top:none;border-left:none">runliu@zyx.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl64" style="height:15.0pt;border-top:none" align="right" height="20">493009</td> <td class="xl64" style="border-top:none;border-left:none">Tham</td> <td class="xl64" style="border-top:none;border-left:none">Bernard</td> <td class="xl64" style="border-top:none;border-left:none">Freshman</td> <td class="xl64" style="border-top:none;border-left:none">Business</td> <td class="xl64" style="border-top:none;border-left:none">Unit 10B</td> <td class="xl64" style="border-top:none;border-left:none">bdtham@zyx.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl64" style="height:15.0pt;border-top:none" align="right" height="20">593018</td> <td class="xl64" style="border-top:none;border-left:none">Wacker</td> <td class="xl64" style="border-top:none;border-left:none">Roland</td> <td class="xl64" style="border-top:none;border-left:none">Freshman</td> <td class="xl64" style="border-top:none;border-left:none">undeclared</td> <td class="xl64" style="border-top:none;border-left:none">Unit 9</td> <td class="xl64" style="border-top:none;border-left:none">rolandwk@zyx.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl64" style="height:15.0pt;border-top:none" align="right" height="20">391210</td> <td class="xl64" style="border-top:none;border-left:none">Xie</td> <td class="xl64" style="border-top:none;border-left:none">Ming-Yang</td> <td class="xl64" style="border-top:none;border-left:none">Junior</td> <td class="xl64" style="border-top:none;border-left:none">English</td> <td class="xl64" style="border-top:none;border-left:none">Sted-2</td> <td class="xl64" style="border-top:none;border-left:none">myxie@zyx.com</td> </tr> </tbody></table>

Expected & 2 Sheet Content

<table border="0" cellpadding="0" cellspacing="0" width="544"><colgroup><col style="width:48pt" span="6" width="64"> <col style="mso-width-source:userset;mso-width-alt:5851;width:120pt" width="160"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td class="xl64" style="height:15.0pt;width:48pt" height="20" width="64">ID</td> <td class="xl64" style="border-left:none;width:48pt" width="64">Last Name</td> <td class="xl64" style="border-left:none;width:48pt" width="64">First Name</td> <td class="xl64" style="border-left:none;width:48pt" width="64">Class</td> <td class="xl64" style="border-left:none;width:48pt" width="64">Major</td> <td class="xl64" style="border-left:none;width:48pt" width="64">Residence</td> <td class="xl64" style="border-left:none;width:120pt" width="160">Email</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" align="right" height="20">391455</td> <td class="xl63" style="border-top:none;border-left:none">Hellung</td> <td class="xl63" style="border-top:none;border-left:none">Anne</td> <td class="xl63" style="border-top:none;border-left:none">Junior</td> <td class="xl63" style="border-top:none;border-left:none">Sociology</td> <td class="xl63" style="border-top:none;border-left:none">Sted-1</td> <td class="xl63" style="border-top:none;border-left:none">annehel11@xyz.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" align="right" height="20">391885</td> <td class="xl63" style="border-top:none;border-left:none">Thorpe</td> <td class="xl63" style="border-top:none;border-left:none">Steven</td> <td class="xl63" style="border-top:none;border-left:none">Junior</td> <td class="xl63" style="border-top:none;border-left:none">Business</td> <td class="xl63" style="border-top:none;border-left:none">off-campus</td> <td class="xl63" style="border-top:none;border-left:none">steventh@abc.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" align="right" height="20">392337</td> <td class="xl63" style="border-top:none;border-left:none">Ramos</td> <td class="xl63" style="border-top:none;border-left:none">Luciana</td> <td class="xl63" style="border-top:none;border-left:none">Sophomore</td> <td class="xl63" style="border-top:none;border-left:none">Engineering</td> <td class="xl63" style="border-top:none;border-left:none">Sted-1</td> <td class="xl63" style="border-top:none;border-left:none">lucramos@sample.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" align="right" height="20">392722</td> <td class="xl63" style="border-top:none;border-left:none">Freehafer</td> <td class="xl63" style="border-top:none;border-left:none">Nancy</td> <td class="xl63" style="border-top:none;border-left:none">Sophomore</td> <td class="xl63" style="border-top:none;border-left:none">Social Studies</td> <td class="xl63" style="border-top:none;border-left:none">Sted-2</td> <td class="xl63" style="border-top:none;border-left:none">nancyfree@sample.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" align="right" height="20">392901</td> <td class="xl63" style="border-top:none;border-left:none">O'Donnell</td> <td class="xl63" style="border-top:none;border-left:none">Martin</td> <td class="xl63" style="border-top:none;border-left:none">Sophomore</td> <td class="xl63" style="border-top:none;border-left:none">Mathematics</td> <td class="xl63" style="border-top:none;border-left:none">Unit 10C</td> <td class="xl63" style="border-top:none;border-left:none">martyo@ijk.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" align="right" height="20">393206</td> <td class="xl63" style="border-top:none;border-left:none">Anderson</td> <td class="xl63" style="border-top:none;border-left:none">Elizabeth</td> <td class="xl63" style="border-top:none;border-left:none">Freshman</td> <td class="xl63" style="border-top:none;border-left:none">undeclared</td> <td class="xl63" style="border-top:none;border-left:none">Unit 7</td> <td class="xl63" style="border-top:none;border-left:none">elandsn@ijk.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" align="right" height="20">393213</td> <td class="xl63" style="border-top:none;border-left:none">Lee</td> <td class="xl63" style="border-top:none;border-left:none">Christina</td> <td class="xl63" style="border-top:none;border-left:none">Freshman</td> <td class="xl63" style="border-top:none;border-left:none">Biology</td> <td class="xl63" style="border-top:none;border-left:none">Unit 10B</td> <td class="xl63" style="border-top:none;border-left:none">chisylee@zyx.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" align="right" height="20">393497</td> <td class="xl63" style="border-top:none;border-left:none">Neipper</td> <td class="xl63" style="border-top:none;border-left:none">Michael</td> <td class="xl63" style="border-top:none;border-left:none">Freshman</td> <td class="xl63" style="border-top:none;border-left:none">undeclared</td> <td class="xl63" style="border-top:none;border-left:none">Unit 9</td> <td class="xl63" style="border-top:none;border-left:none">mneipper@zyx.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" align="right" height="20">393501</td> <td class="xl63" style="border-top:none;border-left:none">LaRosa</td> <td class="xl63" style="border-top:none;border-left:none">Michael</td> <td class="xl63" style="border-top:none;border-left:none">Freshman</td> <td class="xl63" style="border-top:none;border-left:none">Engineering</td> <td class="xl63" style="border-top:none;border-left:none">off-campus</td> <td class="xl63" style="border-top:none;border-left:none">milar@zyx.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" align="right" height="20">393592</td> <td class="xl63" style="border-top:none;border-left:none">Sergienko</td> <td class="xl63" style="border-top:none;border-left:none">Mariya</td> <td class="xl63" style="border-top:none;border-left:none">Freshman</td> <td class="xl63" style="border-top:none;border-left:none">Biology</td> <td class="xl63" style="border-top:none;border-left:none">Unit 10A</td> <td class="xl63" style="border-top:none;border-left:none">mariyaser@zyx.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" align="right" height="20">393599</td> <td class="xl63" style="border-top:none;border-left:none">Zare</td> <td class="xl63" style="border-top:none;border-left:none">Robert</td> <td class="xl63" style="border-top:none;border-left:none">Freshman</td> <td class="xl63" style="border-top:none;border-left:none">undeclared</td> <td class="xl63" style="border-top:none;border-left:none">Unit 8B</td> <td class="xl63" style="border-top:none;border-left:none">rzare@zyx.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" align="right" height="20">393660</td> <td class="xl63" style="border-top:none;border-left:none">Kotas</td> <td class="xl63" style="border-top:none;border-left:none">Jan</td> <td class="xl63" style="border-top:none;border-left:none">Freshman</td> <td class="xl63" style="border-top:none;border-left:none">Mathematics</td> <td class="xl63" style="border-top:none;border-left:none">Unit 9</td> <td class="xl63" style="border-top:none;border-left:none">jankotas@zyx.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" align="right" height="20">393667</td> <td class="xl63" style="border-top:none;border-left:none">Cencini</td> <td class="xl63" style="border-top:none;border-left:none">Andrew</td> <td class="xl63" style="border-top:none;border-left:none">Freshman</td> <td class="xl63" style="border-top:none;border-left:none">undeclared</td> <td class="xl63" style="border-top:none;border-left:none">Unit 10B</td> <td class="xl63" style="border-top:none;border-left:none">acencini@zyx.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" align="right" height="20">393674</td> <td class="xl63" style="border-top:none;border-left:none">Giussani</td> <td class="xl63" style="border-top:none;border-left:none">Laura</td> <td class="xl63" style="border-top:none;border-left:none">Freshman</td> <td class="xl63" style="border-top:none;border-left:none">Chemistry</td> <td class="xl63" style="border-top:none;border-left:none">Unit 8A</td> <td class="xl63" style="border-top:none;border-left:none">lauragius@zyx.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" align="right" height="20">393682</td> <td class="xl63" style="border-top:none;border-left:none">Kupkova</td> <td class="xl63" style="border-top:none;border-left:none">Helena</td> <td class="xl63" style="border-top:none;border-left:none">Freshman</td> <td class="xl63" style="border-top:none;border-left:none">undeclared</td> <td class="xl63" style="border-top:none;border-left:none">Unit 10A</td> <td class="xl63" style="border-top:none;border-left:none">helenag2@zyx.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" align="right" height="20">393683</td> <td class="xl63" style="border-top:none;border-left:none">Hasselberg</td> <td class="xl63" style="border-top:none;border-left:none">Jonas</td> <td class="xl63" style="border-top:none;border-left:none">Freshman</td> <td class="xl63" style="border-top:none;border-left:none">Comp Sci</td> <td class="xl63" style="border-top:none;border-left:none">Unit 8A</td> <td class="xl63" style="border-top:none;border-left:none">jonhasselberg@zyx.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" align="right" height="20">393872</td> <td class="xl63" style="border-top:none;border-left:none">Li</td> <td class="xl63" style="border-top:none;border-left:none">George</td> <td class="xl63" style="border-top:none;border-left:none">Freshman</td> <td class="xl63" style="border-top:none;border-left:none">Business</td> <td class="xl63" style="border-top:none;border-left:none">Unit 7</td> <td class="xl63" style="border-top:none;border-left:none">gli@zyx.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" align="right" height="20">491177</td> <td class="xl63" style="border-top:none;border-left:none">White</td> <td class="xl63" style="border-top:none;border-left:none">Eric</td> <td class="xl63" style="border-top:none;border-left:none">Senior</td> <td class="xl63" style="border-top:none;border-left:none">Math</td> <td class="xl63" style="border-top:none;border-left:none">off-campus</td> <td class="xl63" style="border-top:none;border-left:none">ericwhite@zyx.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" align="right" height="20">492862</td> <td class="xl63" style="border-top:none;border-left:none">Liu</td> <td class="xl63" style="border-top:none;border-left:none">Run</td> <td class="xl63" style="border-top:none;border-left:none">Sophomore</td> <td class="xl63" style="border-top:none;border-left:none">Chemistry</td> <td class="xl63" style="border-top:none;border-left:none">Unit 10A</td> <td class="xl63" style="border-top:none;border-left:none">runliu@zyx.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" align="right" height="20">493009</td> <td class="xl63" style="border-top:none;border-left:none">Tham</td> <td class="xl63" style="border-top:none;border-left:none">Bernard</td> <td class="xl63" style="border-top:none;border-left:none">Freshman</td> <td class="xl63" style="border-top:none;border-left:none">Business</td> <td class="xl63" style="border-top:none;border-left:none">Unit 10B</td> <td class="xl63" style="border-top:none;border-left:none">bdtham@zyx.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" align="right" height="20">593018</td> <td class="xl63" style="border-top:none;border-left:none">Wacker</td> <td class="xl63" style="border-top:none;border-left:none">Roland</td> <td class="xl63" style="border-top:none;border-left:none">Freshman</td> <td class="xl63" style="border-top:none;border-left:none">undeclared</td> <td class="xl63" style="border-top:none;border-left:none">Unit 9</td> <td class="xl63" style="border-top:none;border-left:none">rolandwk@zyx.com</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" align="right" height="20">391210</td> <td class="xl63" style="border-top:none;border-left:none">Xie</td> <td class="xl63" style="border-top:none;border-left:none">Ming-Yang</td> <td class="xl63" style="border-top:none;border-left:none">Junior</td> <td class="xl63" style="border-top:none;border-left:none">English</td> <td class="xl63" style="border-top:none;border-left:none">Sted-2</td> <td class="xl63" style="border-top:none;border-left:none">myxie@zyx.com</td> </tr> </tbody></table>


pleAse anyone help on this case....let me know anything else....

 

[GlennUK]

Explain what rules the copying is supposed to follow, and explain why the main workbook has to stay closed.