Hello, I have a sheet where I want to add datatable to it every week and therefore, I am using append range as it adds on each week.
In the first iteration the sheet only has the table headings.
However, the sheet comes up blank when I try.
Using write range works however, I must use append because I want it to add on each week.
In the local window, the datatable is present.
Please let me know if you can help