Hi, attached is my excel file which there will be inputs on some columns from row 7 onwards. I have 2 questions here regarding this type of format.
How do i compile all of them but keep row 1-6 as it should be fixed. The header should be row 5. I know usually datatable write to excel with headers, but this case im really lost as there are not only headers, but also more rows above.
For each row from row7 onwards, there will be another data table. this datatable is to fill column K onwards, meaning first row of table will fill column K to N, and second row of datatable will fill col O to R and so on…tem.xlsx (26.3 KB)
How do i go about for these?