Copying Alerts From Column on Sheet 1 to Column on Sheet 2

Richard@hearts

I've set up a set of three alerts triggered by a date in a column and it's quite lengthy (but works).  I now want to eliminate rekeying it to 15 other sheets within the same workbook by copying the alerts and placing them in the remaining sheets.  Is there a way to paste them into another sheet?  Please let me know if anyone has had any luck doing this?  Thanks.

Andrée Starå

Hi Richard,

Unfortunately, there isn't a way to copy an alert from one sheet to another. Depending on your use case and structure it could make sense to make a master sheet and the copy that with the Alerts & Actions included.

Please submit an Enhancement Request when you have a moment.

I hope this helps you!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting