Results 1 to 7 of 7

Delete rows in A-I, if time/date in G do not match those in P

Threaded View

  1. #1
    Registered User
    Join Date
    09-08-2012
    Location
    Panama, Panama
    MS-Off Ver
    Excel 2010
    Posts
    7

    Delete rows in A-I, if time/date in G do not match those in P

    Hey everyone,

    Have I got a brainteaser for you! I'm trying to figure out a macro that will:

    1) Scan the time/dates in column P
    2) Scan the time/dates in column G
    3) If the time/dates in column G don't match those in P, then delete the rows from column A-I.

    Attached is a sample of the data.
    This is exif data pulled from camera traps. Columns A-I represent single photos, and K-P are photo sequences (which are typically 10 photos, but can vary). For some reason the temp data in the sequences didn't save to the database, so I have to manually add it. The red column is just to help visually separate photo data from photo set data. There are about 14,000 individual photos, and I'm a bit pressed on time. Any help will be fantastic and +feedback will be given.

    Thanks,
    Zwelty
    Attached Files Attached Files
    Last edited by zwelty; 09-09-2012 at 08:13 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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