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

Hi zwelty,

This clears the whole thing - is the data typical, are there different instructions?

Please Login or Register  to view this content.

Hey xladept,

Thanks for the quick reply!

So your macro works, but only if the date/times in P & G are in the same row. I also realized the data sample I sent wasn't
very helpful, so attached a new one (Sample3.xlsx). The end result should look like the highlighted portions of the worksheet. Below the highlighted bits is how the data currently looks.

For example, referencing Sample3.xlsx, the date/time in G5 & P5 match, but P6 only matches G15, so I need to delete everything in cells A6-I14, and move the cells up so in the end P6 & G6 also match, then continue this through the entire worksheet.

I hope that clarifies things a bit, and you've already wooed me with your initial response.

Zwelty

Hi zwelty,

Try this:

Please Login or Register  to view this content.

You're welcome - but, if you don't want the last section just change:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.