m_vishal_c
Board Regular
- Joined
- Dec 7, 2016
- Messages
- 209
- Office Version
- 365
- 2016
- Platform
- Windows
Hi
I have some data with dates, I need to get notification for all work which are having near by today's date by excel vba
for example
if today's date = date then those data will be popup on screen
this is my main file having these data
[TABLE="width: 139"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Person[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]abc[/TD]
[TD="align: right"]30/05/2019[/TD]
[/TR]
[TR]
[TD]def[/TD]
[TD="align: right"]29/05/2019[/TD]
[/TR]
[TR]
[TD]ghi[/TD]
[TD="align: right"]30/05/2019[/TD]
[/TR]
[TR]
[TD]moh[/TD]
[TD="align: right"]1/06/2019[/TD]
[/TR]
[TR]
[TD]dddd[/TD]
[TD="align: right"]3/06/2019[/TD]
[/TR]
[TR]
[TD]xxxx[/TD]
[TD="align: right"]1/06/2019[/TD]
[/TR]
[TR]
[TD]yyyy[/TD]
[TD="align: right"]3/06/2019[/TD]
[/TR]
</tbody>[/TABLE]
if today's date=date(means 30/5/2019) then below data will popup on screen
[TABLE="width: 139"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Person[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]abc[/TD]
[TD="align: right"]30/05/2019[/TD]
[/TR]
[TR]
[TD]ghi[/TD]
[TD="align: right"]30/05/2019[/TD]
[/TR]
</tbody>[/TABLE]
same as
[TABLE="width: 139"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Person[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]moh[/TD]
[TD="align: right"]1/06/2019[/TD]
[/TR]
[TR]
[TD]xxxx[/TD]
[TD="align: right"]1/06/2019[/TD]
[/TR]
</tbody>[/TABLE]
how it is possible by vba, please let me know.
Heaps thanks
I have some data with dates, I need to get notification for all work which are having near by today's date by excel vba
for example
if today's date = date then those data will be popup on screen
this is my main file having these data
[TABLE="width: 139"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Person[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]abc[/TD]
[TD="align: right"]30/05/2019[/TD]
[/TR]
[TR]
[TD]def[/TD]
[TD="align: right"]29/05/2019[/TD]
[/TR]
[TR]
[TD]ghi[/TD]
[TD="align: right"]30/05/2019[/TD]
[/TR]
[TR]
[TD]moh[/TD]
[TD="align: right"]1/06/2019[/TD]
[/TR]
[TR]
[TD]dddd[/TD]
[TD="align: right"]3/06/2019[/TD]
[/TR]
[TR]
[TD]xxxx[/TD]
[TD="align: right"]1/06/2019[/TD]
[/TR]
[TR]
[TD]yyyy[/TD]
[TD="align: right"]3/06/2019[/TD]
[/TR]
</tbody>[/TABLE]
if today's date=date(means 30/5/2019) then below data will popup on screen
[TABLE="width: 139"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Person[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]abc[/TD]
[TD="align: right"]30/05/2019[/TD]
[/TR]
[TR]
[TD]ghi[/TD]
[TD="align: right"]30/05/2019[/TD]
[/TR]
</tbody>[/TABLE]
same as
[TABLE="width: 139"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Person[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]moh[/TD]
[TD="align: right"]1/06/2019[/TD]
[/TR]
[TR]
[TD]xxxx[/TD]
[TD="align: right"]1/06/2019[/TD]
[/TR]
</tbody>[/TABLE]
how it is possible by vba, please let me know.
Heaps thanks