Results 1 to 10 of 10

Automatically remove unwanted rows

Threaded View

xlsior Automatically remove unwanted... 12-13-2007, 11:25 AM
corinereyes Hi, Put this code in a VB... 12-13-2007, 12:14 PM
xlsior but this will delete only the... 12-14-2007, 08:04 AM
royUK Try using the Forum search.... 12-14-2007, 08:58 AM
xlsior gives me "Compile Error:... 12-14-2007, 09:51 AM
royUK You haven't copied the code... 12-14-2007, 10:08 AM
corinereyes with RoyUk's code maybe you... 12-14-2007, 10:08 AM
corinereyes select column A first then... 12-14-2007, 10:00 AM
shyness_2205 Re: Automatically remove... 01-04-2010, 12:45 AM
teylyn Re: Automatically remove... 01-04-2010, 01:03 AM
  1. #9
    Registered User
    Join Date
    01-04-2010
    Location
    philippines
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Automatically remove unwanted rows

    Hi!

    Can anyone help me with the solution to this problem?
    I want to auto delete the entire row under the column of time with a specific time of 12am to 7am of the next day. I want it to be auto updated from day to day. The only time I need to retain is from 8am until 11pm with its containing row. Appreciate your kind assistance.

    12:00:00 AM
    1:00:00 AM
    2:00:00 AM
    3:00:00 AM
    4:00:00 AM
    5:00:00 AM
    6:00:00 AM
    7:00:00 AM
    8:00:00 AM
    9:00:00 AM
    10:00:00 AM
    11:00:00 AM
    12:00:00 PM
    1:00:00 PM
    2:00:00 PM
    3:00:00 PM
    4:00:00 PM
    5:00:00 PM
    6:00:00 PM
    7:00:00 PM
    8:00:00 PM
    9:00:00 PM
    10:00:00 PM
    11:00:00 PM
    12:00:00 AM
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1