Search : in
By :

Macro to delete rows containing a date

Last answer on Oct 31, 2009 8:52:22 am GMT masterp, on Oct 26, 2009 8:48:44 am GMT 
 Report this message to moderators

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

Configuration: Windows XP Internet Explorer 6.0

Best answers for « Macro to delete rows containing a date » in :
Delete duplicates in an Excel column ShowDelete duplicates in an Excel column To remove duplicates in an Excel column: Click on the Data menu Filter Advanced Filter In this menu, select the column where the duplicates Check the box "Extract without duplication"...
[Sed] Delete one or more lines from a file Show[Sed] Delete one or more lines from a file Removing one (or several) line (s) of a file Syntax: sed '{[/]||[/]}d' sed '{[/][,][/]d' /.../=delimiters n = line number...
Uninstall Outlook Express ShowUninstall Outlook Express Outlook Express is the mail client provided with Microsoft Windows which however unable deletion in the: Add/Remove Programs. If you want to uninstall your system, it is possible to use the uninstall...
Download TuneUp Utilities ShowTuneUp Utilities proposes the following features: - Defragmentation of data supports - Acceleration of the starting up, Internet and Windows - Cleaning of the hard disk - Deletion of useless data - Automatic cleaning and improvement of the...
Download Hard Drive Recovery File Recovery Show
Download MynoSQL Show
UNIX - Files ShowIntroduction to UNIX files In UNIX systems any element is represented in the form of a file. All files are architectured around a single tree structure where the base, called the root, is written "/". File types UNIX systems define different...
Environment variables ShowEnvironment variables An environment variable is a dynamic value loaded into the memory that can be used by several processes operating simultaneously. On most operating systems, the location of some libraries or of the main system executables may...
BIOS optimisation ShowWhat is the BIOS? The BIOS (Basic Input/Output System) is a small memory chip located on the motherboard containing data that define the system parameters. As some BIOS data are written in a ROM, it is not possible to change them, however, certain...
Ask your question Reply

1

 iveal, on Oct 31, 2009 8:52:22 am GMT

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.

   
Reply to iveal
Ask your question Reply
They need your help