I have an excel with more than 1 lakh records, I cannot use write cell activity to set a formula for all cells because it is time consuming. Please suggest a way to set the formula for all rows in a particular column
Hi @Mahalakshmi
Use write cell activity for the one cell and followed by use auto fill activity.
Regards
Gokul