I ahve an excel where the data starts fromB2 and B1 is the column name.
From B2 for each transaction I have to inject a formula . In the formula there is something B1 that is why Ia m planning to inject it per transaction. Is there a way so that B1 gets auto updated to B2 , B3 and so on.
And what should be the source and range in autofill activity
try this @Ritaman_Baral
Sequence.xaml (7.7 KB)
test.xlsx (8.7 KB)
set range as the following
Excel.Sheet("Sheet1").Range("B2")
before
after
if you cant see the activity, make sure modern design experience is enabled
