how to define dynamic range when I export the query data to Excel template file

[mingjueca]

I have one question about setting dynamic range when I export the query data to Excel template file. 

Here is background : 

I create weekly sale by Rep report by pulling query from Oracle and export the result to Excel template file, then rename the template file with week number. 

For example : current week = 08, the final weekly report only shows sales data from wk1-wk8.  

In the template file, , the header of the tab "data"f has 52 columns for W1-W52. Also the header start from A3. 

Each week the query has one more week data and the number of sales Rep changes too.  

Currently I use the fixed range for example : A4-BB4000 which I choose max week and max sales Rep) instead of dynamic range. 

But I don't how to delete the extra columns from wk9-wk52. 

In Excel VBA, it is easy to remove extra week number columns by adding current week number.

Is there a way to achieve this in Alteryx ?  Thanks all

Attached is the excel file which the first sheet is final report should look like and the second sheet is output I used fixed range.

[mingjueca]

Thanks all. 

[mingjueca]

thanks for your solution. but my week number is a little different the regular one. 

for example: 2022-02-28, you can use week function to get Current Week Number is 10th. but my week number is : 18th. 

I can pull the week number from another fiscal week table. but I am not sure how to use it.