Apply for the First row formula to entire column and apply this process to all columns

Help
, ,
1

Hi,

I have 100+ columns of data in an excel, for each column i need to apply a formula and apply it to the entire column and i need to do this to all columns, i can do autofill range one column at a time, but it is taking time to complete the process, is there any other way to apply the formula of the first row of every column to the respective entire column.

TIA
Santhosh

2

Hi @Santhosh_Hyd

If the available activities seem to do the job a bit slower, the alternative is always to use the Invoke VBA activity to execute a macro on your source file. It should go a bit quicker.