css0911
Board Regular
- Joined
- Sep 10, 2013
- Messages
- 127
Dear All
Please help me in this scenario.
I have a master data sheet. Sample as below.
<tbody>
</tbody>
Column C&D shows the gatepass expiry date for respective gates.
User will input the expiry date in B1
Using this sheet i want to generate two sheets showing the matching expiry dates for two gates
Output sheet for Gate 1
<tbody>
</tbody>
Output sheet for Gate 2
<tbody>
</tbody>
Please help me with a vb code
Thanks in advance.
CSS
Please help me in this scenario.
I have a master data sheet. Sample as below.
A | B | C | D | |
1 | Input Date | 20/01/2018 | ||
2 | Sr.No. | Emp. Name | Gate1 | Gate2 |
3 | 1 | Thomas | 20/01/2018 | 01/02/2018 |
4 | 2 | Bobby` | 10/03/2018 | 20/01/2018 |
5 | 3 | Kim | 20/01/2018 | 20/01/2018 |
<tbody>
</tbody>
Column C&D shows the gatepass expiry date for respective gates.
User will input the expiry date in B1
Using this sheet i want to generate two sheets showing the matching expiry dates for two gates
Output sheet for Gate 1
A | B | c | |
1 | Sr.No | Emp. Name | Gate1 |
2 | 1 | Thomas | 20/01/2018 |
3 | 2 | Kim | 20/01/2018 |
<tbody>
</tbody>
Output sheet for Gate 2
A | B | C | |
1 | Sr.No | Emp.Name | Gate2 |
2 | 1 | Bobby | 20/01/2018 |
3 | 2 | Kim | 20/01/2018 |
<tbody>
</tbody>
Please help me with a vb code
Thanks in advance.
CSS