Unanswered

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!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (2)

Report

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:

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (1)

Report

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
==========

Was this reply helpful? Yes No
JAFTB 11 on at

Like (0)

Report

Thank you! This worked for me.

Was this reply helpful? Yes No
JAFTB 11 on at

Like (1)

Report

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

Was this reply helpful? Yes No