Hi,
I have a Power Automate Script to run a series of OFFICE Scripts in an excel file to update data in a Pivot Table from an external data source.
The pivot table data can will vary from day to day in row length but fixed columns.
Was looking for a script either in Excel that would copy and paste the data items or the whole pivot to a new sheet so I can add some extra columns to it and add protection to some cells. Hence needing a copy.
Also if there is a way to do the same in Power Automate then that would also work.
Have tried recording a copy and paste but that does not work, so any ideas on how to do this would be appreciated.
Thanks in anticipation.
Andy
