How to achieve drop-down a row which contains formulas

excel

#1

Hi guys,
i have met a problem of how to pull down the formula range in excel.Like this:
image
Thanks in advance!


#2

Hello,
If I understand the problem is with Excel Spreadsheet and want to apply in excel :
if you want to create a simple drop down. Go to Data -> Data Validation -> Allow (List) -> Select Range then drop down appears.
To pull down formula, simply you can drag the corner of the cell till the rows you desire to copy or Use Paste Special formulas or VBA code .

Hope it might help.


#3

HI @PavaniDilip,
Thank you for your replay.Are u told me the implement method in excel file?And i want to know the method to achieve it with UIpath.If u know, please tell me.Thank u


#4

Hello @kidding,

could you please try below files?

Main.xaml (15.7 KB)
results.xlsx (8.1 KB)

Keep up updated :slight_smile:

Thanks,
Pankaj


#5

Hi @Pankaj.Patil ,
It works! Except a little difference that my selector is like this:


Thanks a lot!