Transfer Data from One Workbook to Another Workbook

mlarson · Sep 10, 2011

Hi everybody, I could really use your help on what is probably a pretty easy problem, but it has me stumped.

I have two workbooks (Workbook1 and Workbook2). I am trying to transfer the values from Column C of Workbook2 (Num4) to Column G of Workbook1 (Num4) but only IF the values in columns A,B,D,E,F for a particular row are identical between the two workbooks (column C values do NOT have to be identical).

If the values of A,B,D,E,F are indeed identical, then I want the value of Column C in Workbook2 to be added to column G of Workbook1. However, if the values of columns A,B,D,E,F are NOT identical then instead of the Column C (from Workbook2) being transferred, I’d prefer to have a zero (0) added to column G of Workbook1.

For example, below I show samples of the two workbooks as well as the output (which is Workbook1 with column G filled-in). As you can see, the value of “7” from Workbook2 in cell C5 is added to the Output cell G5 (because it met the conditions of having identical values in columns A,B,D,E,F). On the other hand, the value of “9” from Workbook2 in cell C4 is NOT added to the Output cell G4 (because condition was NOT met of identical values in columns A, B,D,E,F), and a zero (0) was placed in Output cell G4 instead.

If you know of how to make this happen I would greatly appreciate it. I would prefer a macro as opposed to a formula that had to be copied and pasted in all the output cells. Not sure if it matters, but each workbook only has one spreadsheet. Thank you!

<table class="MsoNormalTable" style="width: 443.8pt; margin-left: 4.65pt; border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="592"> <tbody><tr style="height: 15pt;"> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> <td style="width: 63.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="85" nowrap="nowrap"> A
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> B
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> C
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> D
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap"> E
</td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="107" nowrap="nowrap"> F
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> G
</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

1

</td> <td style="width: 63.8pt; border: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="85" nowrap="nowrap"> WORKBOOK1
</td> <td style="width: 48pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> <td style="width: 48pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> <td style="width: 48pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> <td style="width: 60pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 80pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="107" nowrap="nowrap">
</td> <td style="width: 48pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

2

</td> <td style="width: 63.8pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="85" nowrap="nowrap"> Date
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> Time
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> Num1
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> Day
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap"> Num2
</td> <td style="width: 80pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="107" nowrap="nowrap"> Num3
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> Num4
</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

3

</td> <td style="width: 63.8pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="85" nowrap="nowrap">

8/12/2010

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

10:00

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

2

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> Thursday
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">

44

</td> <td style="width: 80pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="107" nowrap="nowrap">

1

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

4

</td> <td style="width: 63.8pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="85" nowrap="nowrap">

8/12/2010

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

11:00

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

3

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> Thursday
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">

44

</td> <td style="width: 80pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="107" nowrap="nowrap">

10

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

5

</td> <td style="width: 63.8pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="85" nowrap="nowrap">

8/12/2010

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

12:00

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

4

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> Thursday
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">

44

</td> <td style="width: 80pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="107" nowrap="nowrap">

20

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

6

</td> <td style="width: 63.8pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="85" nowrap="nowrap">

8/12/2010

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

13:00

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

8

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> Thursday
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">

45

</td> <td style="width: 80pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="107" nowrap="nowrap">

1

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

7

</td> <td style="width: 63.8pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="85" nowrap="nowrap">

8/12/2010

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

14:00

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

5

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> Thursday
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">

45

</td> <td style="width: 80pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="107" nowrap="nowrap">

10

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

8

</td> <td style="width: 63.8pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="85" nowrap="nowrap">

8/12/2010

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

15:00

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

4

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> Thursday
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">

46

</td> <td style="width: 80pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="107" nowrap="nowrap">

20

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> <td style="width: 63.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="85" nowrap="nowrap">
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="107" nowrap="nowrap">
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> <td style="width: 63.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="85" nowrap="nowrap"> A
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> B
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> C
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> D
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap"> E
</td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="107" nowrap="nowrap"> F
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

1

</td> <td style="width: 63.8pt; border: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="85" nowrap="nowrap"> WORKBOOK2
</td> <td style="width: 48pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> <td style="width: 48pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> <td style="width: 48pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> <td style="width: 60pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 80pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="107" nowrap="nowrap">
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

2

</td> <td style="width: 63.8pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="85" nowrap="nowrap"> Date
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> Time
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> Num4
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> Day
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap"> Num2
</td> <td style="width: 80pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="107" nowrap="nowrap"> Num3
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

3

</td> <td style="width: 63.8pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="85" nowrap="nowrap">

8/12/2010

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

10:00

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

8

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> Thursday
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">

43

</td> <td style="width: 80pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="107" nowrap="nowrap">

1

</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

4

</td> <td style="width: 63.8pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="85" nowrap="nowrap">

8/12/2010

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

10:00

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

9

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> Thursday
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">

44

</td> <td style="width: 80pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="107" nowrap="nowrap">

7

</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

5

</td> <td style="width: 63.8pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="85" nowrap="nowrap">

8/12/2010

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

10:00

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

7

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> Thursday
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">

44

</td> <td style="width: 80pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="107" nowrap="nowrap">

20

</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

6

</td> <td style="width: 63.8pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="85" nowrap="nowrap">

8/12/2010

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

10:00

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

5

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> Thursday
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">

45

</td> <td style="width: 80pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="107" nowrap="nowrap">

1

</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

7

</td> <td style="width: 63.8pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="85" nowrap="nowrap">

8/12/2010

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

10:00

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

8

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> Thursday
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">

45

</td> <td style="width: 80pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="107" nowrap="nowrap">

10

</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

8

</td> <td style="width: 63.8pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="85" nowrap="nowrap">

8/12/2010

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

10:00

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

8

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> Thursday
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">

46

</td> <td style="width: 80pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="107" nowrap="nowrap">

20

</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> <td style="width: 63.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="85" nowrap="nowrap">
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="107" nowrap="nowrap">
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> <td style="width: 63.8pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="85" nowrap="nowrap"> A
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> B
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> C
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> D
</td> <td style="width: 60pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap"> E
</td> <td style="width: 80pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="107" nowrap="nowrap"> F
</td> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> G
</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

1

</td> <td style="width: 63.8pt; border: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="85" nowrap="nowrap"> OUTPUT
</td> <td style="width: 48pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> <td style="width: 48pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> <td style="width: 48pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> <td style="width: 60pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">
</td> <td style="width: 80pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="107" nowrap="nowrap">
</td> <td style="width: 48pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">
</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

2

</td> <td style="width: 63.8pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="85" nowrap="nowrap"> Date
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> Time
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> Num1
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> Day
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap"> Num2
</td> <td style="width: 80pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="107" nowrap="nowrap"> Num3
</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> Num4
</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

3

</td> <td style="width: 63.8pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="85" nowrap="nowrap">

8/12/2010

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

10:00

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

2

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> Thursday
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">

44

</td> <td style="width: 80pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="107" nowrap="nowrap">

1

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

0.00

</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

4

</td> <td style="width: 63.8pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="85" nowrap="nowrap">

8/12/2010

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

11:00

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

3

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> Thursday
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">

44

</td> <td style="width: 80pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="107" nowrap="nowrap">

10

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

0.00

</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

5

</td> <td style="width: 63.8pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="85" nowrap="nowrap">

8/12/2010

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

12:00

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

4

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> Thursday
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">

44

</td> <td style="width: 80pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="107" nowrap="nowrap">

20

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

7.00

</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

6

</td> <td style="width: 63.8pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="85" nowrap="nowrap">

8/12/2010

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

13:00

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

8

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> Thursday
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">

45

</td> <td style="width: 80pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="107" nowrap="nowrap">

1

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

5.00

</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

7

</td> <td style="width: 63.8pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="85" nowrap="nowrap">

8/12/2010

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

14:00

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

5

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> Thursday
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">

45

</td> <td style="width: 80pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="107" nowrap="nowrap">

10

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

8.00

</td> </tr> <tr style="height: 15pt;"> <td style="width: 48pt; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

8

</td> <td style="width: 63.8pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="85" nowrap="nowrap">

8/12/2010

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

15:00

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

4

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap"> Thursday
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="80" nowrap="nowrap">

46

</td> <td style="width: 80pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="107" nowrap="nowrap">

20

</td> <td style="width: 48pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" valign="bottom" width="64" nowrap="nowrap">

8.00

</td> </tr> </tbody></table>

Saagar · Sep 10, 2011

Based on you saying "...it has me stumped" I assume you have some excel VB/macro coding experience.

For the comparison between sheets, you may ignore column D as it is dependent upon the date and if the date is same, it will automatically remain the same.

I will spell out the approach. If you aren't able to write the code, I will try to help you with the code.

1. Apply auto filters to all columns in workbook2
2. Write code to fetch values A B, E and F from workbook1 and apply them to filters in workbook2.
3. Assuming there is either only one match or none, always get the values in the visible row below the header row. If the filters return no values, it will be blank or it will your desired value. Capture that from column C and put it in workbook1 column G.

Good luck!

AlphaFrog · Sep 10, 2011

In your example data, shouldn't column G be all zero results?

WorkBook 2 column B only has one time (10:00), and that matches only one row (3) in WorkBook 1. But the other columns for row 3 don't match. So there are no rows in the two WorkBooks with an exact A,B,D,E,F match.

mlarson · Sep 10, 2011

Alpha, yes, that was a typo on my part. Workbook2 should have times 10:00, 11:00, 12:00, 13:00, 14:00, 15:00.

mlarson · Sep 10, 2011

Saagar, I have some VB/macro experience but it is very limited and I would consider myself more of a beginner than anything else. If you don't mind providing the code that you think would work, I would appreciate it. By the way, the time for Workbook2 should be 10:00, 11:00, 12:00, 13:00, 14:00, 15:00. Thanks.

Saagar · Sep 10, 2011

I may not be able to write code until Sunday evening. Meanwhile try this since you have VB experience.

- Enable auto filters in workbook2.
- Go to workbook1 and start recording a macro.
- Copy A5 from workbook1 and apply it in column A filter of workbook2
- Repeat the steps for B5,E5,F5 in workbook1 and apply filters in workbook2 column B, E and F
- Now when filters are complete, workbook2 will show the filtered row.
- Select cell C1 in workbook2 and hit the "arrow down" key to select the filtered answer in C5.
- Copy and paste it in workbook1 G5
- Stop recording the macro.

The created macro will have all pieces of code that you require. Modify the code and put it in a loop to execute it for all rows in workbook1.

If you are not successful, reply back and I will see if I can work on the code tomorrow evening.

Good luck!

mlarson · Sep 11, 2011

Saagar, if you don't mind sending me the code I would appreciate it. I recorded the macro and it works for row 5 as mentioned in the steps you outlined, but I'm afraid I'm not well-versed enough to properly expand the range or add the loop code. Thanks in advance for your help!

Saagar · Sep 11, 2011

No problem, reply back with the macro code you recorded and I will modify and put it in a loop to work for you.

mlarson · Sep 11, 2011

Here you go. Thanks!

Code:

Sub MatchCellsTry1()
'
' MatchCellsTry1 Macro
'

'
    Range("A5").Select
    Selection.Copy
    Windows("Match Cells 2.xlsx").Activate
    ActiveSheet.Range("$A$1:$F$8").AutoFilter Field:=1
    Application.Left = 31
    Application.Top = 248.5
    Windows("Match Cells 1.xlsm").Activate
    Range("B5").Select
    Application.CutCopyMode = False
    Selection.Copy
    Windows("Match Cells 2.xlsx").Activate
    ActiveSheet.Range("$A$1:$F$8").AutoFilter Field:=2, Criteria1:="12:00"
    Windows("Match Cells 1.xlsm").Activate
    Range("E5").Select
    Application.CutCopyMode = False
    Selection.Copy
    Windows("Match Cells 2.xlsx").Activate
    ActiveSheet.Range("$A$1:$F$8").AutoFilter Field:=5
    Windows("Match Cells 1.xlsm").Activate
    Range("F5").Select
    Application.CutCopyMode = False
    Selection.Copy
    Windows("Match Cells 2.xlsx").Activate
    ActiveSheet.Range("$A$1:$F$8").AutoFilter Field:=6
    Application.Left = 19
    Application.Top = 172
    Range("C5").Select
    Application.CutCopyMode = False
    Selection.Copy
    Application.Left = 19.75
    Application.Top = 214.75
    Windows("Match Cells 1.xlsm").Activate
    Range("G5").Select
    ActiveSheet.Paste
    Application.Left = 7.75
    Application.Top = 74.5
End Sub

Saagar · Sep 11, 2011

Larson - Thanks for the code. I will get back to you tomorrow evening.

Transfer Data from One Workbook to Another Workbook

mlarson

Well-known Member

Excel Facts

Saagar

Board Regular

AlphaFrog

MrExcel MVP

mlarson

Well-known Member

mlarson

Well-known Member

Saagar

Board Regular

mlarson

Well-known Member

Saagar

Board Regular

mlarson

Well-known Member

Saagar

Board Regular

Similar threads

Forum statistics

Share this page

Transfer Data from One Workbook to Another Workbook

Well-known Member

Excel Facts

Board Regular

MrExcel MVP

Well-known Member

Well-known Member

Board Regular

Well-known Member

Board Regular

Well-known Member

Board Regular

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock