Answered

Duplicate worksheet and rename when new email is received

(0) Share

Report

Posted on by JAFTB

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!

All responses (4)

Answers (1)

JAFTB 11 on at

Like (1)

Report

Re: Duplicate worksheet and rename when new email is received

This website is really cool! Thanks for the link. I'm sure it'll help with future script problems.
JAFTB 11 on at

Like (0)

Report

Re: Duplicate worksheet and rename when new email is received

Thank you! This worked for me.
efialttes 14,756 on at

Like (1)

Report

Re: Duplicate worksheet and rename when new email is received

Hi @JAFTB
So you already try to overcome your challenge with Office Scripts, right?
If not, you will find promising stuff here
https://kokoroe.konomi.app/en/docs/office-scripts/worksheet/copy/
Hope this helps
==========
Verified answer

BCBuizer 22,262 Super User 2025 Season 1 on at

Like (2)

Report

Re: Duplicate worksheet and rename when new email is received

Hi @JAFTB ,

What you may try is to use the "Get file content" action to get the contents of the original file and then create a new file using the output of that action for the File Content field: