Duplicate Excel Sheet

Help Studio
,
1

As the title states, I want to know if there is any way to duplicate an Excel sheet to a new sheet in the same workbook. I have tried with Read/Write range and keeping the formatting, but it only pastes the data and not the cell colors, =SUM etc.
Is there a way to create such result without the use of macros?

2

The solution I created this far is through hotkeys on the specific sheet.
I use 4 hotkey activities in a row and they look like this:

  1. ALT + hom
  2. tab
  3. " "
  4. enter

With that, a new sheet with the previous sheets name+(2) will be created for anyone who encountered the same problem as me. Hope this helps and if someone has any other good solution I will leave this thread open for now!

3

Hi @Robert_Wennberg,

Try to use Copy Sheet activity