Hi first time user of ozgrid so thankyou need some excel help
would like vba code to delete dates in column G .the date column has this text 13/03/2018 6:00:00 AM in it. the file has a heading in row 1
So the file will always have 300 to 500 rows in it and I would like to have the code delete the rows with all dates 2 days before todays date,and delete the rows with all dates 2 days after todays date.i have copied lots of different code from the net and none of them would work as I wanted after editing .
Thankyou again example below
regards simon
[TABLE="border: 0, cellpadding: 0, cellspacing: 0, width: 575"]
Order ID
[/td]Order Line Qty
[/td]Order Line SKU
[/td]Purchase Order ID
[/td]Bill Company
[/td]Order Status
[/td]Date Required
[/td]Pick Slip Abbrev.
[/td]SO-35144
[/td]
[TD="align: right"]1[/TD]
3PTi-SoAnl-3ph
[/td]38836 - 102728
[/td]Operations Co Pty Ltd (NEW)
[/td]On Hold
[/td]
[TD="align: right"]13/03/2018[/TD]
SO-35144
[/td]
[TD="align: right"]1[/TD]
3pTi-AlLab
[/td]38836 - 102728
[/td]erations Co Pty Ltd (NEW)
[/td]On Hold
[/td]
[TD="align: right"]13/03/2018[/TD]
[/TABLE]