Creating a new tab from existing

[Piyalipiu27]

Suppose I have different tabs with monthly data.

Now I want to copy the last month's tab and create a new tab in the same excel, without changing the formula.

Please help on that!

[messi007]

@Piyalipiu27 could you share a sample data with what you expect to have? It will help us to give you the solution.

Regards,

[Piyalipiu27]

I have uploaded a file with Jan Feb and Mar

I want to create a tab called Apr with the same table format as in Mar

[messi007]

@Piyalipiu27,

Please see below:

Attached the workflow,

Hope this helps!

Regards

[danilang]

Hi @Piyalipiu27 

There's no way within Alteryx to recreate the formulas on an excel worksheet.  You'll have to use a vba script to copy the tab if you want to copy the formulas as well..  Here's an article on how to call a vba script from Alteryx.   

Dan