Macro to delete rows containing a date
Closed
Hello,
On a daily basis I populate data on different worksheets. Meaning on each day I have to delete T-2 data to populate T-1 data.
I would like a macro to select a date to delete rows from each worksheet containing the date in Column A
Your assistance will be greatly appreciated
Kind Regards
Master P
On a daily basis I populate data on different worksheets. Meaning on each day I have to delete T-2 data to populate T-1 data.
I would like a macro to select a date to delete rows from each worksheet containing the date in Column A
Your assistance will be greatly appreciated
Kind Regards
Master P
Related:
- Macro to delete rows containing a date
- How to delete a row in a table in word - Guide
- How to delete whatsapp account without login - Guide
- How to delete whatsapp account without phone - Guide
- How to delete badoo account - Guide
- How to delete skype account - Guide
2 responses
Dear Sir,
Please use the following and insert the specific date in the place of DATE:
EndCount = Range("DateCount").Value '# of rows
application.Goto Reference:="DateStart"
For LoopCount = 1 To EndCount Step 1
If ActiveCell.Value = "DATE" Then
Selection.EntireRow.Hidden = True
End If
ActiveCell.Offset(1, 0).Activate
Next LoopCount
Thanks.
Please use the following and insert the specific date in the place of DATE:
EndCount = Range("DateCount").Value '# of rows
application.Goto Reference:="DateStart"
For LoopCount = 1 To EndCount Step 1
If ActiveCell.Value = "DATE" Then
Selection.EntireRow.Hidden = True
End If
ActiveCell.Offset(1, 0).Activate
Next LoopCount
Thanks.
