output to show the data from line 2 and ignore first line

[Inactive User]

Team,

am  linking a data output to excel MACRO where it as macro button on first line.
1) the output should ignore 1st line and macro button. 
2) it should override the data every time i run the ALTERYX .

Is this can be implemented - kindly advice.

Thanks,

Guru

[pedrodrfaria]

Hi @Inactive User 

In the Data output you can select to output to a specific range and select to append to an existing sheet or overwrite it while preserving the format

[Inactive User]

Hello @pedrodrfaria 

Am not getting that options to select the range.

[pedrodrfaria]

@Inactive User 

Which version are you on?

Here is the screenshot when dealing with a .xlsm file and you can see me specifying the range. I'm on version 2020.4

[Inactive User]

Hi @pedrodrfaria 

Am using version 2019.3 - is there any way to create an output based on my specification. 

[pedrodrfaria]

@Inactive User 

I believe with the version you are in, you will not be able to do this, only if you were to upgrade to a newer version.

Are you able to upgrade to a newer version?

[Inactive User]

@pedrodrfaria 
Not possible due to restrictions... Thanks for your help in this regards.