How to drag down a formula

Help StudioX
, ,
1

I have a formula in a cell called C2 and its in D2. I want to drag down D2 so the next row is D3,and D4 and so forth automatically, until the very last value in the C column

bonus question is how do I tell studiox the last row variable in the C column and have it drag D all the way down to that??

2

First what you can do is use the read range activity to read the datatable, then using datatable.Rows.Count you can get the number of rows that are available and pass that number into the autofill activity.

3

Hi there i have a similar question i want to drag a text to the last row from cell B7. How do i find my last roe and tell the bot to drag it down?