Autofill Excel Function

Hi @Isyraf_Salahudin

Please try this,

  1. You can read the excel data and store in a data table (dtTable)
    2 And in autofill give range as “A2:A” + dtTable.rows.count.tostring

Thanks

1 Like