motherindia
Board Regular
- Joined
- Oct 15, 2015
- Messages
- 218
Hi Friends,
I Have two Sheets.
Sheet 1 Contains following data;
<tbody>
</tbody>
<tbody>
</tbody>
ID NO Date
<tbody>
</tbody>
I Have two Sheets.
Sheet 1 Contains following data;
ID No | Country | Sdate | E Date | Type | Nature | Text Contetns | Days |
1111111 | Finland | 26-Jun-15 | 1-Jul-15 | LD | Paid | ALL | 6 |
1111111 | Ireland | 2-Jul-15 | 7-Jul-15 | LD | Paid | ALL | 6 |
1111111 | Ireland | 8-Jul-15 | 8-Jul-15 | LD | Paid | ALL | 0.5 |
1111111 | Ireland | 8-Jul-15 | 8-Jul-15 | PD | unpaid | ALL | 0.5 |
<tbody>
</tbody>
Sheet2 Contains I want to math ID NO and Date of Shee2 with Sheet1 and copy the matching rows to Sheet3. If no matches found then it should be blank | | | | | | | |
<tbody>
</tbody>
ID NO Date
1111111 | 26-Jun-15 |
1111111 | 27-Jun-15 |
1111111 | 28-Jun-15 |
1111111 | 29-Jun-15 |
1111111 | 30-Jun-15 |
1111111 | 01-Jul-15 |
1111111 | 02-Jul-15 |
1111111 | 03-Jul-15 |
1111111 | 04-Jul-15 |
1111111 | 05-Jul-15 |
1111111 | 06-Jul-15 |
1111111 | 07-Jul-15 |
1111111 | 08-Jul-15 |
1111111 | 10-Jul-15 |
1111111 | 11-Jul-15 |
1111111 | 12-Jul-15 |
<tbody>
</tbody>