Search and Match and show the result

[Vishaal]

Hi All,

Thanks in advance,

We want to check and match from two sheet as per given sheets

First Sheet from where we will compare and match

Excel 2010 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A​

[/th][th]

B​

[/th][th]

C​

[/th][th]

D​

[/th][th]

E​

[/th][th]

F​

[/th][th]

G​

[/th][th]

H​

[/th][th]

I​

[/th][th]

J​

[/th][th]

K​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

1​

[/td][td]

S.No.​

[/td][td]

Age Group​

[/td][td]

Danial​

[/td][td]

Chrix​

[/td][td]

Rocky​

[/td][td]

Ricky​

[/td][td]

​

[/td][td]

Danial​

[/td][td]

Chrix​

[/td][td]

Rocky​

[/td][td]

Ricky​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

2​

[/td][td]

​

[/td][td]

​

[/td][td]

Ronaldo​

[/td][td]

Pamela​

[/td][td]

Donald​

[/td][td]

messy​

[/td][td]

​

[/td][td]

Ronaldo​

[/td][td]

Pamela​

[/td][td]

Donald​

[/td][td]

messy​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

3​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

4​

[/td][td]

1​

[/td][td]

20​

[/td][td]

Yes​

[/td][td]

Na​

[/td][td]

Yes​

[/td][td]

Na​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

5​

[/td][td]

2​

[/td][td]

30​

[/td][td]

Na​

[/td][td]

Na​

[/td][td]

Na​

[/td][td]

Na​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

6​

[/td][td]

3​

[/td][td]

40​

[/td][td]

Na​

[/td][td]

Na​

[/td][td]

Na​

[/td][td]

Na​

[/td][td]

​

[/td][td]

2​

[/td][td]

3​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

7​

[/td][td]

4​

[/td][td]

50​

[/td][td]

Yes​

[/td][td]

Yes​

[/td][td]

Na​

[/td][td]

Na​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

4​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

8​

[/td][td]

5​

[/td][td]

60​

[/td][td]

Yes​

[/td][td]

Na​

[/td][td]

Na​

[/td][td]

Yes​

[/td][td]

​

[/td][td]

​

[/td][td]

1​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

9​

[/td][td]

6​

[/td][td]

70​

[/td][td]

Na​

[/td][td]

Yes​

[/td][td]

Na​

[/td][td]

Yes​

[/td][td]

​

[/td][td]

1​

[/td][td]

​

[/td][td]

5​

[/td][td]

​

[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]


Second Sheet from where we match and show the data

Excel 2010 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A​

[/th][th]

B​

[/th][th]

C​

[/th][th]

D​

[/th][th]

E​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

1​

[/td][td]

S.No.​

[/td][td]

Danial​

[/td][td]

Chrix​

[/td][td]

Rocky​

[/td][td]

Ricky​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

2​

[/td][td]

​

[/td][td]

Ronaldo​

[/td][td]

Pamela​

[/td][td]

Donald​

[/td][td]

messy​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

3​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

4​

[/td][td]

1​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

5​

[/td][td]

2​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

6​

[/td][td]

3​

[/td][td]

​

[/td][td]

​

[/td][td]

Yes​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

7​

[/td][td]

4​

[/td][td]

Yes​

[/td][td]

​

[/td][td]

​

[/td][td]

Yes​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

8​

[/td][td]

5​

[/td][td]

​

[/td][td]

Yes​

[/td][td]

Yes​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

9​

[/td][td]

6​

[/td][td]

​

[/td][td]

​

[/td][td][/td][td]

​

[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]


We will check and match if Range H4:H9 will match Range A4:A9 and if there is Yes in B4:B9 then it will copy the S.No. and heading and paste in first sheet coloumn,

Result sheet

Excel 2010 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A​

[/th][th]

B​

[/th][th]

C​

[/th][th]

D​

[/th][th]

E​

[/th][th]

F​

[/th][th]

G​

[/th][th]

H​

[/th][th]

I​

[/th][th]

J​

[/th][th]

K​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

1​

[/td][td]

S.No.​

[/td][td]

Age Group​

[/td][td]

Danial​

[/td][td]

Chrix​

[/td][td]

Rocky​

[/td][td]

Ricky​

[/td][td]

​

[/td][td]

Danial​

[/td][td]

Chrix​

[/td][td]

Rocky​

[/td][td]

Ricky​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

2​

[/td][td]

​

[/td][td]

​

[/td][td]

Ronaldo​

[/td][td]

Pamela​

[/td][td]

Donald​

[/td][td]

messy​

[/td][td]

​

[/td][td]

Ronaldo​

[/td][td]

Pamela​

[/td][td]

Donald​

[/td][td]

messy​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

3​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

4​

[/td][td]

1​

[/td][td]

20​

[/td][td]

Yes​

[/td][td]

Na​

[/td][td]

Yes​

[/td][td]

Na​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

5​

[/td][td]

2​

[/td][td]

30​

[/td][td]

Na​

[/td][td]

Na​

[/td][td]

Na​

[/td][td]

Na​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

6​

[/td][td]

3​

[/td][td]

40​

[/td][td]

Na​

[/td][td]

Na​

[/td][td]

Na​

[/td][td]

Na​

[/td][td]

​

[/td][td]

2​

[/td][td]

3​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

7​

[/td][td]

4​

[/td][td]

50​

[/td][td]

Yes​

[/td][td]

Yes​

[/td][td]

Na​

[/td][td]

Na​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

4​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

8​

[/td][td]

5​

[/td][td]

60​

[/td][td]

Yes​

[/td][td]

Na​

[/td][td]

Na​

[/td][td]

Yes​

[/td][td]

​

[/td][td]

​

[/td][td]

1​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

9​

[/td][td]

6​

[/td][td]

70​

[/td][td]

Na​

[/td][td]

Yes​

[/td][td]

Na​

[/td][td]

Yes​

[/td][td]

​

[/td][td]

1​

[/td][td]

​

[/td][td]

5​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

10​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

11​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

12​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

5​

[/td][td]

4​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

13​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

Rocky​

[/td][td]

Ricky​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

14​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

Donald​

[/td][td]

messy​

[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]

Help pls

 

[DanteAmor]

I have a couple of doubts.


The names in the headings are in two rows?
Your example result "5 Rocky Donald" is not correct, since 5 (cell J9) is in row 6 (row 9).


You can comment

 

[Vishaal]

Thanks for giving the time DanteAmor Ji

1. Yes, the names in headings are in two row
2. "5" is a number which have "Yes" in second data

I m checking the following

If H4 value from first data is match with second data A4 and B4 have "Yes" - copy the headings and matched number and paste in first data

If H5 value from first data is match with second data A5 and B5 have "Yes" - copy the headings and matched number and paste in first data

If H6 value from first data is match with second data A6 and B6 have "Yes" - copy the headings and matched number and paste in first data

For coloumn I
If I4 value from first data is match with second data A4 and C4 have "Yes" - copy the headings and matched number and paste in first data

If I5 value from first data is match with second data A5 and C5 have "Yes" - copy the headings and matched number and paste in first data

Coloumn J
If J4 value from first data is match with second data A4 and D4 have "Yes" - copy the headings and matched number and paste in first data

Pls confirm if all the points are clear

 

[DanteAmor]

I adjusted the code to put the resulting numbers below the headings in case of having several results.

Sheet1
<table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:47.52px;" /><col style="width:86.5px;" /><col style="width:67.49px;" /><col style="width:61.78px;" /><col style="width:58.93px;" /><col style="width:55.13px;" /><col style="width:76.04px;" /><col style="width:67.49px;" /><col style="width:61.78px;" /><col style="width:58.93px;" /><col style="width:55.13px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td><td >F</td><td >G</td><td >H</td><td >I</td><td >J</td><td >K</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="background-color:#ffff00; ">S.No.</td><td style="background-color:#ffff00; ">Age Group</td><td style="background-color:#ffff00; ">Danial</td><td style="background-color:#ffff00; ">Chrix</td><td style="background-color:#ffff00; ">Rocky</td><td style="background-color:#ffff00; ">Ricky</td><td > </td><td style="background-color:#ffff00; ">Danial</td><td style="background-color:#ffff00; ">Chrix</td><td style="background-color:#ffff00; ">Rocky</td><td style="background-color:#ffff00; ">Ricky</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; ">Ronaldo</td><td style="background-color:#ffff00; ">Pamela</td><td style="background-color:#ffff00; ">Donald</td><td style="background-color:#ffff00; ">messy</td><td > </td><td style="background-color:#ffff00; ">Ronaldo</td><td style="background-color:#ffff00; ">Pamela</td><td style="background-color:#ffff00; ">Donald</td><td style="background-color:#ffff00; ">messy</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="text-align:right; ">1</td><td style="text-align:right; ">20</td><td >Yes</td><td >Na</td><td >Yes</td><td >Na</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="text-align:right; ">2</td><td style="text-align:right; ">30</td><td >Na</td><td >Na</td><td >Na</td><td >Na</td><td > </td><td > </td><td > </td><td style="text-align:right; ">3</td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="text-align:right; ">3</td><td style="text-align:right; ">40</td><td >Na</td><td >Na</td><td >Na</td><td >Na</td><td > </td><td style="text-align:right; ">2</td><td style="text-align:right; ">3</td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="text-align:right; ">4</td><td style="text-align:right; ">50</td><td >Yes</td><td >Yes</td><td >Na</td><td >Na</td><td > </td><td > </td><td > </td><td > </td><td style="text-align:right; ">4</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="text-align:right; ">5</td><td style="text-align:right; ">60</td><td >Yes</td><td >Na</td><td >Na</td><td >Yes</td><td > </td><td > </td><td style="text-align:right; ">1</td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="text-align:right; ">6</td><td style="text-align:right; ">70</td><td >Na</td><td >Yes</td><td >Na</td><td >Yes</td><td > </td><td style="text-align:right; ">1</td><td > </td><td style="text-align:right; ">5</td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td >Rocky</td><td >Ricky</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td >Donald</td><td >messy</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td style="text-align:right; ">3</td><td style="text-align:right; ">4</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td style="text-align:right; ">5</td><td > </td></tr></table>
Sheet2
<table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:38.02px;" /><col style="width:55.13px;" /><col style="width:50.38px;" /><col style="width:48.48px;" /><col style="width:43.72px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="background-color:#ffff00; ">S.No.</td><td style="background-color:#ffff00; ">Danial</td><td style="background-color:#ffff00; ">Chrix</td><td style="background-color:#ffff00; ">Rocky</td><td style="background-color:#ffff00; ">Ricky</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="background-color:#ffff00; "> </td><td style="background-color:#ffff00; ">Ronaldo</td><td style="background-color:#ffff00; ">Pamela</td><td style="background-color:#ffff00; ">Donald</td><td style="background-color:#ffff00; ">messy</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="text-align:right; ">1</td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="text-align:right; ">2</td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="text-align:right; ">3</td><td > </td><td > </td><td >Yes</td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="text-align:right; ">4</td><td >Yes</td><td > </td><td > </td><td >Yes</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="text-align:right; ">5</td><td > </td><td >Yes</td><td >Yes</td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="text-align:right; ">6</td><td > </td><td > </td><td > </td><td > </td></tr></table>

Try the code and give me your opinion.

Sub Search_and_Match()
  Dim sh1 As Worksheet, sh2 As Worksheet
  Dim lr As Long, lc As Long, col As Long, lr2 As Long
  Dim c As Range, f As Range, r As Range
  '
  Set sh1 = Sheets("Sheet1")
  Set sh2 = Sheets("Sheet2")
  lr = sh1.Range("A" & Rows.Count).End(xlUp).Row
  lc = sh1.Cells(1, Columns.Count).End(xlToLeft).Column
  Set r = sh1.Range("H4", sh1.Cells(lr, lc))
  r.Offset(r.Rows.Count + 2).ClearContents
  For Each c In r
    If c.Value <> "" Then
      col = c.Column - r.Cells(1, 1).Column + 1
      Set f = sh2.Range("A:A").Find(c.Value, , xlValues, xlWhole)
      If Not f Is Nothing Then
        If f.Offset(, col).Value = "Yes" Then
          sh1.Cells(lr + 3, c.Column).Resize(2).Value = sh1.Cells(1, c.Column).Resize(2).Value
          lr2 = sh1.Cells(Rows.Count, c.Column).End(xlUp).Row + 1
          sh1.Cells(lr2, c.Column).Value = c.Value
        End If
      End If
    End If
  Next
End Sub

 

[Vishaal]

Many thanks DanteAmor Ji

Its working for me and saved my lots of time

Thanks sir ji

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.

 

[Vishaal]

Hi Sir,

We are using the code and want some modification, like

1. if we need to add or remove header data from two rows to one rows or six row, how can we do that
2. how can we fix that the result will always show from after five or six rows from last data

help pls

 

[Vishaal]

Hi DanteAmor Ji,

if we are using your code with the sample data its working fine but when we are using with the following sheet its not working, we have also check it with making some changes in your code

Excel 2010 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A​

[/th][th]

B​

[/th][th]

C​

[/th][th]

D​

[/th][th]

E​

[/th][th]

F​

[/th][th]

G​

[/th][th]

H​

[/th][th]

I​

[/th][th]

J​

[/th][th]

K​

[/th][th]

L​

[/th][th]

M​

[/th][th]

N​

[/th][th]

O​

[/th][th]

P​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

1​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

Danial​

[/td][td]

Chrix​

[/td][td]

Rocky​

[/td][td]

Ricky​

[/td][td]

log​

[/td][td]

ghun​

[/td][td]

​

[/td][td]

Danial​

[/td][td]

Chrix​

[/td][td]

Rocky​

[/td][td]

Ricky​

[/td][td]

log​

[/td][td]

ghun​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

2​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

Ronaldo​

[/td][td]

Pamela​

[/td][td]

Donald​

[/td][td]

messy​

[/td][td]

sanju​

[/td][td]

safi​

[/td][td]

​

[/td][td]

Ronaldo​

[/td][td]

Pamela​

[/td][td]

Donald​

[/td][td]

messy​

[/td][td]

sanju​

[/td][td]

safi​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

3​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

shika​

[/td][td]

rghu​

[/td][td]

randy​

[/td][td]

john​

[/td][td]

vijju​

[/td][td]

rodi​

[/td][td]

​

[/td][td]

shika​

[/td][td]

rghu​

[/td][td]

randy​

[/td][td]

john​

[/td][td]

vijju​

[/td][td]

rodi​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

4​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

lovely​

[/td][td]

rick​

[/td][td]

flair​

[/td][td]

prave​

[/td][td]

archi​

[/td][td]

tina​

[/td][td]

​

[/td][td]

lovely​

[/td][td]

rick​

[/td][td]

flair​

[/td][td]

prave​

[/td][td]

archi​

[/td][td]

tina​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

5​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

rinku​

[/td][td]

mone​

[/td][td]

rashmi​

[/td][td]

peter​

[/td][td]

novit​

[/td][td]

emli​

[/td][td]

​

[/td][td]

rinku​

[/td][td]

mone​

[/td][td]

rashmi​

[/td][td]

peter​

[/td][td]

novit​

[/td][td]

emli​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

6​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

7​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

8​

[/td][td]

1​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

9​

[/td][td]

2​

[/td][td]

17000​

[/td][td]

700​

[/td][td]

Na​

[/td][td]

Na​

[/td][td]

Na​

[/td][td]

Na​

[/td][td]

Na​

[/td][td]

Na​

[/td][td]

​

[/td][td]

​

[/td][td]

1​

[/td][td]

1​

[/td][td]

​

[/td][td]

1​

[/td][td]

1​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

10​

[/td][td]

3​

[/td][td]

83000​

[/td][td]

300​

[/td][td]

Na​

[/td][td]

​

[/td][td]

​

[/td][td]

Na​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

2​

[/td][td]

​

[/td][td]

​

[/td][td]

2​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

11​

[/td][td]

4​

[/td][td]

92000​

[/td][td]

200​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

12​

[/td][td]

5​

[/td][td]

42000​

[/td][td]

200​

[/td][td]

Na​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

1​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

13​

[/td][td]

6​

[/td][td]

69000​

[/td][td]

900​

[/td][td]

​

[/td][td]

​

[/td][td]

Na​

[/td][td]

​

[/td][td]

Na​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

1​

[/td][td]

​

[/td][td]

1​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

14​

[/td][td]

7​

[/td][td]

93000​

[/td][td]

300​

[/td][td]

​

[/td][td]

Na​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

15​

[/td][td]

8​

[/td][td]

31000​

[/td][td]

100​

[/td][td]

​

[/td][td]

Na​

[/td][td]

​

[/td][td]

Na​

[/td][td]

​

[/td][td]

Na​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

16​

[/td][td]

9​

[/td][td]

56000​

[/td][td]

600​

[/td][td]

Na​

[/td][td]

Na​

[/td][td]

​

[/td][td]

Na​

[/td][td]

Na​

[/td][td]

Na​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

1​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

17​

[/td][td]

10​

[/td][td]

58000​

[/td][td]

800​

[/td][td]

Na​

[/td][td]

Na​

[/td][td]

​

[/td][td]

Na​

[/td][td]

​

[/td][td]

Na​

[/td][td]

​

[/td][td]

2​

[/td][td]

4​

[/td][td]

​

[/td][td]

3​

[/td][td]

​

[/td][td]

3​

[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]

Second Sheet for search and match

Excel 2010 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A​

[/th][th]

B​

[/th][th]

C​

[/th][th]

D​

[/th][th]

E​

[/th][th]

F​

[/th][th]

G​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

1​

[/td][td]

​

[/td][td]

Danial​

[/td][td]

Chrix​

[/td][td]

Rocky​

[/td][td]

Ricky​

[/td][td]

log​

[/td][td]

ghun​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

2​

[/td][td]

​

[/td][td]

Ronaldo​

[/td][td]

Pamela​

[/td][td]

Donald​

[/td][td]

messy​

[/td][td]

sanju​

[/td][td]

safi​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

3​

[/td][td]

​

[/td][td]

shika​

[/td][td]

rghu​

[/td][td]

randy​

[/td][td]

john​

[/td][td]

vijju​

[/td][td]

rodi​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

4​

[/td][td]

​

[/td][td]

lovely​

[/td][td]

rick​

[/td][td]

flair​

[/td][td]

prave​

[/td][td]

archi​

[/td][td]

tina​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

5​

[/td][td]

​

[/td][td]

rinku​

[/td][td]

mone​

[/td][td]

rashmi​

[/td][td]

peter​

[/td][td]

novit​

[/td][td]

emli​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

6​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

7​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

8​

[/td][td]

1​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

9​

[/td][td]

2​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

Yes​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

10​

[/td][td]

3​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

Yes​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

11​

[/td][td]

4​

[/td][td]

​

[/td][td]

Yes​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

12​

[/td][td]

5​

[/td][td]

Yes​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

13​

[/td][td]

6​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

Yes​

[/td][td]

​

[/td][td]

Yes​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

14​

[/td][td]

7​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

15​

[/td][td]

8​

[/td][td]

​

[/td][td]

​

[/td][td]

Yes​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

16​

[/td][td]

9​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

17​

[/td][td]

10​

[/td][td]

​

[/td][td]

Yes​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

18​

[/td][td]

11​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

Yes​

[/td][td]

​

[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet2[/td][/tr][/table]

Result Sheet

Excel 2010 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A​

[/th][th]

B​

[/th][th]

C​

[/th][th]

D​

[/th][th]

E​

[/th][th]

F​

[/th][th]

G​

[/th][th]

H​

[/th][th]

I​

[/th][th]

J​

[/th][th]

K​

[/th][th]

L​

[/th][th]

M​

[/th][th]

N​

[/th][th]

O​

[/th][th]

P​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

1​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

Danial​

[/td][td]

Chrix​

[/td][td]

Rocky​

[/td][td]

Ricky​

[/td][td]

log​

[/td][td]

ghun​

[/td][td]

​

[/td][td]

Danial​

[/td][td]

Chrix​

[/td][td]

Rocky​

[/td][td]

Ricky​

[/td][td]

log​

[/td][td]

ghun​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

2​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

Ronaldo​

[/td][td]

Pamela​

[/td][td]

Donald​

[/td][td]

messy​

[/td][td]

sanju​

[/td][td]

safi​

[/td][td]

​

[/td][td]

Ronaldo​

[/td][td]

Pamela​

[/td][td]

Donald​

[/td][td]

messy​

[/td][td]

sanju​

[/td][td]

safi​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

3​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

shika​

[/td][td]

rghu​

[/td][td]

randy​

[/td][td]

john​

[/td][td]

vijju​

[/td][td]

rodi​

[/td][td]

​

[/td][td]

shika​

[/td][td]

rghu​

[/td][td]

randy​

[/td][td]

john​

[/td][td]

vijju​

[/td][td]

rodi​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

4​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

lovely​

[/td][td]

rick​

[/td][td]

flair​

[/td][td]

prave​

[/td][td]

archi​

[/td][td]

tina​

[/td][td]

​

[/td][td]

lovely​

[/td][td]

rick​

[/td][td]

flair​

[/td][td]

prave​

[/td][td]

archi​

[/td][td]

tina​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

5​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

rinku​

[/td][td]

mone​

[/td][td]

rashmi​

[/td][td]

peter​

[/td][td]

novit​

[/td][td]

emli​

[/td][td]

​

[/td][td]

rinku​

[/td][td]

mone​

[/td][td]

rashmi​

[/td][td]

peter​

[/td][td]

novit​

[/td][td]

emli​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

6​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

7​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

8​

[/td][td]

1​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

9​

[/td][td]

2​

[/td][td]

17000​

[/td][td]

700​

[/td][td]

Na​

[/td][td]

Na​

[/td][td]

Na​

[/td][td]

Na​

[/td][td]

Na​

[/td][td]

Na​

[/td][td]

​

[/td][td]

​

[/td][td]

1​

[/td][td]

1​

[/td][td]

​

[/td][td]

1​

[/td][td]

1​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

10​

[/td][td]

3​

[/td][td]

83000​

[/td][td]

300​

[/td][td]

Na​

[/td][td]

​

[/td][td]

​

[/td][td]

Na​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

2​

[/td][td]

​

[/td][td]

​

[/td][td]

2​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

11​

[/td][td]

4​

[/td][td]

92000​

[/td][td]

200​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

12​

[/td][td]

5​

[/td][td]

42000​

[/td][td]

200​

[/td][td]

Na​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

1​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

13​

[/td][td]

6​

[/td][td]

69000​

[/td][td]

900​

[/td][td]

​

[/td][td]

​

[/td][td]

Na​

[/td][td]

​

[/td][td]

Na​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

1​

[/td][td]

​

[/td][td]

1​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

14​

[/td][td]

7​

[/td][td]

93000​

[/td][td]

300​

[/td][td]

​

[/td][td]

Na​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

15​

[/td][td]

8​

[/td][td]

31000​

[/td][td]

100​

[/td][td]

​

[/td][td]

Na​

[/td][td]

​

[/td][td]

Na​

[/td][td]

​

[/td][td]

Na​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

16​

[/td][td]

9​

[/td][td]

56000​

[/td][td]

600​

[/td][td]

Na​

[/td][td]

Na​

[/td][td]

​

[/td][td]

Na​

[/td][td]

Na​

[/td][td]

Na​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][td]

1​

[/td][td]

​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

17​

[/td][td]

10​

[/td][td]

58000​

[/td][td]

800​

[/td][td]

Na​

[/td][td]

Na​

[/td][td]

​

[/td][td]

Na​

[/td][td]

​

[/td][td]

Na​

[/td][td]

​

[/td][td]

2​

[/td][td]

4​

[/td][td]

​

[/td][td]

3​

[/td][td]

​

[/td][td]

3​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

18​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

19​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

20​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td]

4​

[/td][td][/td][td][/td][td][/td][td]

3​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

21​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td]

Chrix​

[/td][td][/td][td][/td][td][/td][td]

ghun​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

22​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td]

Pamela​

[/td][td][/td][td][/td][td][/td][td]

safi​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

23​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td]

rghu​

[/td][td][/td][td][/td][td][/td][td]

rodi​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

24​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td]

rick​

[/td][td][/td][td][/td][td][/td][td]

tina​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

25​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td]

mone​

[/td][td][/td][td][/td][td][/td][td]

emli​

[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]

in this sheet we will check only last filled row data to second sheet data
i mean k99
when we add data on 10th row then we will check only k1010, we will not check any other data
When we add data on 11th row then we will check only k1111, we will not check any other data
When we add data on 12th row then we will check only k121, we will not check any other data

all the points are same as previous question, except the above point

help pls