This is helpful, but not exactly what I am looking for. Sheet 1 should write a range of the date and category count. Then sheet 2 should add that new row in sheet 1 to sheet 2. So sheet 2 will always add columns and sheet 1 just has the one column to move over. There should not be 3 tables used.
Can you show the rest of the sequence?
I am founding difficulty in writing data from data table into excel sheet template. The Excel sheet template as 11 row which 11th row is total column.If the datatable contains 13 rows and if im writing to template its automatically overriding the total column.Any way to insert row dynamically after 10th row to accomodate new rows and calculate the total without any overriding
