I have two sheets.
The first one has incoming data that dynamically updates. The fields are
I want to duplicate the rows in a second sheet but only if the email field in sheet 1 does NOT end with or contain "@gmail.com".
Any idea on how can I accomplish this?