Importrange

[Jeff_Hager]

@Johnny onEdit isn’t going to work. Like I mentioned, you need to use the onChange trigger instead. See if any of this helps.

Clear all column's data

Here’s a handful of posts that might help. As far as the trigger, be sure to look for this icon when writing the script. This allows you to set up a trigger. Just make sure it’s an onChange trigger. [image]