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"]
[tr][td]Order ID
[/td][td]Order Line Qty
[/td][td]Order Line SKU
[/td][td]Purchase Order ID
[/td][td]Bill Company
[/td][td]Order Status
[/td][td]Date Required
[/td][td]Pick Slip Abbrev.
[/td][/tr][tr][td]SO-35144
[/td]
[TD="align: right"]1[/TD]
3PTi-SoAnl-3ph
[/td][td]38836 - 102728
[/td][td]Operations Co Pty Ltd (NEW)
[/td][td]On Hold
[/td]
[TD="align: right"]13/03/2018[/TD]
SO-35144
[/td]
[TD="align: right"]1[/TD]
3pTi-AlLab
[/td][td]38836 - 102728
[/td][td]erations Co Pty Ltd (NEW)
[/td][td]On Hold
[/td]
[TD="align: right"]13/03/2018[/TD]
[/TABLE]