Macro to delete rows when columns F *or* G don't contain certian data

[Slea]

1) Thank you for even looking at this. I am brand spanking new at doing this, and I'm enjoying making macros, but I know very little.

2) Okay, I've got a spreadsheet where there are two columns, one labeled "Source" and one labeled "Destination." These are columns F and G, respectively. I only want to see items where either Source=Florida **or** Destination=Florida.

3) I know how to hide and delete all rows where Source=Florida for instance, but of course, that hides and deletes things where Destination=Florida.

3) So, of course, with the knowledge I have, I can only create a spreadsheet where both the Source AND the Destination=Florida, but that almost never happens. I need some sort of "Or" operator here.

4) Just to be clear, if the word "Florida" occurs in either column F **or** in column G, I need to keep it, but anything that has any other source or destination, I don't need.

Am I making sense? I hope I am b/c I have been working on this for hours and I'm not sure I understand myself anymore!

[AlphaFrog]

This hides the rows if column F=Forida, then hides the remaining rows if column G=Florida (OR), then deletes the remaining visible rows and unhides the Florida rows.

Please Login or Register  to view this content.

[Slea]

That left me with a blank spreadsheet?

I think it is deleting stuff where F may not be "Florida" but G is.

[AlphaFrog]

Do you have data in columns A:E ? Field numbering (columns) starts at the first column with data.

Is exactly "Florida" in column F and G? No leading or trailing extra characters?

[Slea]

My fault!

This is why I shouldn't mess with macros late at night. In the fresh light of day... it works PERFECTLY! Thanks so much!