I'm reading in a section of an Excel sheet into a data table so I can use it as a template in an output sheet. What I'd like to do is make a copy / duplicate of my template data table, then use find and replace to fill in the values from a source data set, then write the updated template data table to the output Excel sheet. I'll be doing this numerous times until the source data is iterated through. I can't find an easy way to make a cop of a data table though.
BTW, when I asked Copilot, the example it gave involved Power Automate. This all needs to execute within Power Automate Desktop.
