Hello,
I'm trying to find a way to have an email (with a specific subject line) trigger Excel to duplicate a worksheet and rename it to the subject line of the email.
I've been able to set up the email trigger and the creation of a new sheet with the email subject name. I just don't know how to copy the items from my template worksheet into the newly made sheet while maintaining the formatting and row/column heights. Would having Power Automate run a script be easier than trying to automate this?
The template that I'm trying to copy is a Gantt Chart that isn't set up as a table. I'm hoping to keep making duplicates of it within the same workbook as the new emails arrive (if possible).
Thanks!
